sum D48:D50 if =40 amt over=OT

April 9, 2011 at 13:26:32
Specs: Windows XP
Summing weekly hours, if suml of D48:D50 is = < 40 then leave blank, if >40 put the amt over 40 in cell - trying to calculate overtime hours on a weekly basis

See More: sum D48:D50 if =40 amt over=OT

Report •

#1
April 10, 2011 at 09:25:57
TrY:

=IF(SUM(D48:D50)<=40,"",SUM(D48:D50)-40)

MIKE

http://www.skeptic.com/


Report •

#2
April 11, 2011 at 10:57:42
Thanks a lot! Looks so simple when you see it!

Report •
Related Solutions


Ask Question