I need help with the IF Statement

[Guest]

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.

 

[Guest]

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

 

[Guest]

Will this work?

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

HTH,
Elkar

 

[Guest]

Hi Jeff

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

 

[Guest]

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

 

[Sandy Mann]

Jeff,

Being as both parts of your formula had the same subtractions apart from the
+24, you could use:

=H10-A10-G10+(H10>A10)*24

--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk