Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If blank statement
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(C2D2,TEXT(F2-C2,"h:mm"),TEXT(F2-D2,"h:mm")) Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
returning blank cell in an if statement | Excel Worksheet Functions | |||
if statement when cell is blank | Excel Worksheet Functions | |||
add blank row in an if statement | Excel Discussion (Misc queries) | |||
keep cell blank when false in IF statement | Excel Discussion (Misc queries) | |||
IF statement when formula result is blank | Excel Worksheet Functions |