IIF IS NULL Problem

S

scott

I'm trying to test a cell to return a blank "" or the number. If cell B3
contains nothing, how can i return a blank?

i'm using below formula, but it gives me an error.

=IF(IS NULL(B3),"",B3)
 
D

Dave R.

Try this changing A1 to B3:

=OR(ISBLANK(A1),A1="")

=IF(OR(ISBLANK(A1),A1=""),"",A1)
 
G

Gord Dibben

Scott

Maybe =IF(ISBLANK(B3),"",B3)

Note: if B3 is blank due to its having an IF formula that returns "", it will
pass the ISBLANK test, so ISBLANK is not really NULL.


Gord Dibben Excel MVP
 
D

Dave R.

Gord Dibben said:
Maybe =IF(ISBLANK(B3),"",B3)

Note: if B3 is blank due to its having an IF formula that returns "", it will
pass the ISBLANK test, so ISBLANK is not really NULL.
Click to expand...


Do you mean to say that it will FAIL the ISBLANK test?
 
M

Myrna Larson

If you check help, you'll not find (1) any functions that consist of two words
separated by a space, or (2) any function involving NULL. Maybe you are
thinking of VBA.

The worksheet function is ISBLANK (note one word, not 2).
 
Top