IF formula
 

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!

IF formula
 

=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.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=485937

IF formula
 

=F2-G2-SUM(M2:U2)

--

HTH

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


"dtmd" wrote in message
...
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!

IF formula
 

Thank you so much! That did the trick.

"goober" wrote:


=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.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=485937

IF formula
 

You're welcome.


--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=485937