Thread: IF formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dtmd
 
Posts: n/a
Default 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!