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
|