IIF IS NULL Problem

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)

Try this changing A1 to B3:

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

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


"scott" <sbailey@mileslumber.com> wrote in message
news:%23m2lKab8EHA.208@TK2MSFTNGP12.phx.gbl...
> 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)
>
>

why does iif combined with is null fail?


"Dave R." <daverx@hotmail.com> wrote in message
news:u7OHTmb8EHA.2196@TK2MSFTNGP14.phx.gbl...
> Try this changing A1 to B3:
>
> =OR(ISBLANK(A1),A1="")
>
> =IF(OR(ISBLANK(A1),A1=""),"",A1)
>
>
> "scott" <sbailey@mileslumber.com> wrote in message
> news:%23m2lKab8EHA.208@TK2MSFTNGP12.phx.gbl...
>> 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)
>>
>>
>
>

is null is not an XL function...

You could also just use

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



In article <uSPHD#e8EHA.2124@TK2MSFTNGP15.phx.gbl>,
"scott" <sbailey@mileslumber.com> wrote:

> why does iif combined with is null fail?

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

On Mon, 3 Jan 2005 11:06:13 -0600, "scott" <sbailey@mileslumber.com> wrote:

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

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:735jt05jasfhg3hhdin98fhi1k436j898v@4ax.com...
> 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?

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

On Mon, 3 Jan 2005 11:06:13 -0600, "scott" <sbailey@mileslumber.com> wrote:

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