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

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