IF functions and blank cells

**ccolesUT** · 10-28-2011, 04:28 PM

When using an IF function in Excel, it gives me a result even if the reference field is blank... as if it were a zero. How do I tell the function to give a blank result if the reference field is blank? So frustrating... HELP!

**daddylonglegs** · 10-28-2011, 04:32 PM

Try like this

=IF(A1="","",original_formula)

**ccolesUT** · 10-28-2011, 04:36 PM

Either you are a genius or I'm a moron. Either way, thanks so much!

**FundCFO** · 10-28-2011, 04:38 PM

you are not a moron. Sometimes it isn't so obvious when you have been going in circles for hours!!! Been there!!!!

**FundCFO** · 10-28-2011, 04:36 PM

I am sure there is some more technical way, but I would probably just use a nested IF function like this.....

IF blank, then leave blank, else do _____ for me...... seems to work fine.

=IF(D7="","","DO THIS IF STMT….")

(blank) =>
1 DO THIS IF STMT….
2 DO THIS IF STMT….
3 DO THIS IF STMT….