ExcelBanter - Set a cell to blank (Null)

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Set a cell to blank (Null) (https://www.excelbanter.com/excel-programming/307503-set-cell-blank-null.html)

Bill Agee

Set a cell to blank (Null)

How can I set a set to Null? I am ussing a formula in a worksheet to pickup
values from another worksheet.

I need to use a formula such as "=IF(ISBLANK(Sheet1!B2), Null,Sheet1!B2)"

If I just say "=Sheet1!B2, then the blank value gets set to 0. I don't want
0, but rather Null.

Tom Ogilvy

Set a cell to blank (Null)

=IF(ISBLANK(Sheet1!B2), "",Sheet1!B2)

--
Regards,
Tom Ogilvy

"Bill Agee" wrote in message
nk.net...
How can I set a set to Null? I am ussing a formula in a worksheet to
pickup
values from another worksheet.

I need to use a formula such as "=IF(ISBLANK(Sheet1!B2), Null,Sheet1!B2)"

If I just say "=Sheet1!B2, then the blank value gets set to 0. I don't
want
0, but rather Null.

All times are GMT +1. The time now is 07:47 PM.