Thread: leave sum of j7 at 40 or less put excess in k7
View Single Post
  #3  
Old March 17th, 2010, 06:55 PM posted to microsoft.public.excel.worksheet.functions
Fred Smith[_4_]
external usenet poster
  
Posts: 2,386
Default 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 news