IIF IS NULL Problem

[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)

 

[Dave R.]

Try this changing A1 to B3:

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

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

 

[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

 

[Dave R.]

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.

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

 

[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).

 

[scott]

why does iif combined with is null fail?

Try this changing A1 to B3:

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

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

 

[JE McGimpsey]

is null is not an XL function...

You could also just use

=IF(B3="","",B3)