Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need an alterate result to "0" for null value
Hello,
I have a worksheet that references cells from another worksheet but if the cell is blank, it produces a "0". This "0" is changing the behavior of other formulas so is there a formula I can use that will either change the "0" to a blank or #N/A? Thanks, Jaret |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need an alterate result to "0" for null value
Try either of these:
=IF(Sheet1!$E$15="",NA(),Sheet1!E15) =IF(Sheet1!$E$15="","",Sheet1!E15) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "mcmilja" wrote in message ... Hello, I have a worksheet that references cells from another worksheet but if the cell is blank, it produces a "0". This "0" is changing the behavior of other formulas so is there a formula I can use that will either change the "0" to a blank or #N/A? Thanks, Jaret |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperion Essbase Excel Add-in - returning text ("0") for null valu | Excel Discussion (Misc queries) | |||
when a "check box" is checked, a "result" to be shown in another c | Excel Discussion (Misc queries) | |||
How to write parameter query with "or is null" criteria | New Users to Excel | |||
cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
"IF"- "THEN" type Formula based on Null value | Excel Worksheet Functions |