I need help with the IF Statement

J

Jeff Thomas

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(H10>A10,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.
 
B

Bobby

Jeff
If your formula works other wise, try:
=IF(AND(H10>0,A10>0),IF(H10>A10,H10-A10-G10,H10-A10+24-G10),0)

HTH
 
E

Elkar

Will this work?

=IF(AND(A10=0,H10=0),0,IF(H10>A10,H10-A10-G10,H10-A10+24-G10))

HTH,
Elkar
 
K

Kassie

Hi Jeff

Try
IF(OR(A10="",H10=0,A10="",H10=""),0,IF((H10>A10,H10-A10-G10,H10-A10+24-G10))
hth
 
J

Jeff Thomas

Bobby,
Works great, I knew it was something easy, I used excel in the Army and
became very proficient with it, so I knew the statement could be used, I just
could no remember all the variables.

Thanks again.

Jeff
 
Top