| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| setting a cell to 'empty' or blank or null ? | New Users to Excel | |||
| I want to use a different cell if my date field is NULL/BLANK | Excel Worksheet Functions | |||
| If null, make cell blank | Excel Worksheet Functions | |||
| Replace null string with blank cell | Excel Discussion (Misc queries) | |||
| make cell contents equal to null value - not blank, but empty | Excel Worksheet Functions | |||
Hybrid Mode
