ExcelBanter - IIF IS NULL Problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IIF IS NULL Problem (https://www.excelbanter.com/excel-worksheet-functions/8584-iif-null-problem.html)

scott

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)

Dave R.

Try this changing A1 to B3:

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

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

"scott" wrote in message
...
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

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

Dave R.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
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).

On Mon, 3 Jan 2005 11:06:13 -0600, "scott" 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)

scott

why does iif combined with is null fail?

"Dave R." wrote in message
...
Try this changing A1 to B3:

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

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

"scott" wrote in message
...
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)

JE McGimpsey

is null is not an XL function...

You could also just use

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

In article ,
"scott" wrote:

why does iif combined with is null fail?

All times are GMT +1. The time now is 02:10 AM.