How are empty cells referenced in Excel in IF statements?
 

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

How are empty cells referenced in Excel in IF statements?
 

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


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=551166

How are empty cells referenced in Excel in IF statements?
 

Hi!

Try something like this:

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

Biff

"MOnewt" wrote in message
...
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="",...).

How are empty cells referenced in Excel in IF statements?
 

Mo:

This works in Excel 2003:

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

HTH

"MOnewt" wrote:

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

How are empty cells referenced in Excel in IF statements?
 

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


"pdberger" wrote in message
...
Mo:

This works in Excel 2003:

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

HTH

"MOnewt" wrote:

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

How are empty cells referenced in Excel in IF statements?
 

=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(A15," ","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(A15,"","X") - a null is displayed
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"MOnewt" wrote in message
...
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="",...).

How are empty cells referenced in Excel in IF statements?
 

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.

"MOnewt" wrote:

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