Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula? | Excel Worksheet Functions | |||
writing a formula for a colored value | New Users to Excel | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |