Prev: Replace Cells with Column names in functions?
Next: Insert Picture
From: payroll function payroll on 17 Mar 2010 11:16

From: Pete_UK on 17 Mar 2010 13:42
It would help if you used this white space to describe your problem in
more detail.

Pete

On Mar 17, 3:16 pm, payroll function <payroll
funct...(a)discussions.microsoft.com> wrote:
>

From: Fred Smith on 17 Mar 2010 14:55
If your sum is in h7, use:
J7: =min(40,h7)
K7: =if(h7>40,h7-40,0)

Regards,
Fred

"payroll function" <payroll function(a)discussions.microsoft.com> wrote in
message news:D3E14944-8E9C-4E52-A70A-249DE4DB7AB3(a)microsoft.com...
>

 | 
Pages: 1
Prev: Replace Cells with Column names in functions?
Next: Insert Picture