If blank statement

[Jim]

I'm using the IF statement below on my spreadsheet, but cell F2 could
potentially be blank, and I'm having trouble writing that into the statement.
If F2 is blank, I want it to disregard the formula and dislay 0. If it's
not blank, then use the formula.

=IF(C2>D2,TEXT(F2-C2,"h:mm"),TEXT(F2-D2,"h:mm"))

Thanks in advance.

 

[JoeU2004]

If F2 is blank, I want it to disregard the formula and dislay 0.

=if(F2="", 0, TEXT(F2-MAX(C2,D2), "h:mm"))

If you format the cell with custom format h:mm, zero will be displayed as
0:00, if that's what you really want (I would).


----- original message -----

 

[Max]

Try COUNT: =IF(COUNT(C2,D2,F2)<3,"",<your expression>)
Success? hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik

 

[Max]

Ah, a simpler way, since you say

If F2 is blank, I want it to disregard the formula and display 0.

=IF(F2="",0,IF(C2>D2,TEXT(F2-C2,"h:mm"),TEXT(F2-D2,"h:mm")))
Strap on a front IF to check on F2
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

 

[Jim]

both of these formulas give me the desired results - thanks!