How are empty cells referenced in Excel in IF statements?

M

MOnewt

I am trying to use an IF... function to populate a field if another field is
not empty. The "" empty, or null expression is not valid (A3="",...).
 
C

Chip Pearson

You've got it backwards. It should be
=IF(A3="","Empty","Full")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
B

Bernard Liengme

=IF(ISBLANK(A1), "do this", "else do that")
But beware of functions that display nothing!
An experiment:
In A1 enter value 10
In B 1 enter formula =IF(A1>5," ","X") - a space is displayed
In C1 enter formula =IF(ISBLANK(B1),"blank","not blank")
In D1 enter formula =IF(B1=" ","blank","not blank")
Then try with =IF(A1>5,"","X") - a null is displayed
 
K

kassie

Do not really make out what your problem is. If you want to do something
only if a specific cell is not empty, you should use <>"", and not ="".
+IF(A3<>"",A3*C3,"") means IF A3 is not equal to nothing - iow contains a
value - THEN multiply A3 with C3, ELSE leave blank. Be careful though. A
space is <>"". Text is <>"", and a number is <> "". If you want A3 to
contain a numeric value as critria, but it contains a 0 or alfa character,
you will get an #N/A result.
 
Top