IF formula

[dtmd]

I have a spreadsheet (timesheet) that has a column (F) defaulted to 8. I
need this row to subtract the numbers entered into rows G, M-U only. For
instance - the 8 is regular hours (Column F). If someone takes 8 hours of
Sick leave (column O) - I want the 8 in the Column F to go to zero. If they
took 3 hours, I want it to go to 5 hours. The other tricky part is that if
they took 4 hours of Leave Sick (column O) and 4 hours of Leave Annual
(Column M) - both those amounts should be deducted from Column F. Any
suggestions would be great!

 

[goober]

=SUM(8-(G10+M10+N10+O10+P10+Q10+R10+S10+T10+U10))
Should do what you want.


=SUM(8-SUM(G10,M10:U10))
Does the same thing only using arrays.

This will also give you a negative if the numbers entered exceed 8.

Hope it helps.

 

[Bob Phillips]

=F2-G2-SUM(M2:U2)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[dtmd]

Thank you so much! That did the trick.

 

[goober]

You're welcome.