Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |