How are empty cells referenced in Excel in IF statements?

[Guest]

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="",...).

 

[Bearacade]

=IF(ISBLANK(A3), "A3 is Empty", "A3 is NOT empty"

 

[Biff]

Hi!

Try something like this:

=IF(LEN(A3)>0,............................

Biff

 

[Guest]

Mo:

This works in Excel 2003:

=IF(A3<>"","Empty","Full")

HTH

 

[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

 

[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

 

[Guest]

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.