View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff Thomas
 
Posts: n/a
Default I need help with the IF Statement

I am trying to use the if statement if excel, I have it working for the most
part, but it needs on more variable, and I am confused.

All numbers are times from a time clock so they are 24hr format with
hundreths.

=IF(H10A10,H10-A10-G10,H10-A10+24-G10)

the only problem is when H10 and A10 are blank, I get 24 as a result, I know
that is what I have told it to do, but I also want it to return zero if H10
and A10 are blank, or have 0's.