leave sum of j7 at 40 or less put excess in k7
 

leave sum of j7 at 40 or less put excess in k7
 

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
wrote:

leave sum of j7 at 40 or less put excess in k7
 

If your sum is in h7, use:
J7: =min(40,h7)
K7: =if(h740,h7-40,0)

Regards,
Fred

"payroll function" <payroll wrote in
message ...