Need an alterate result to "0" for null value

M

mcmilja

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
 
R

RagDyer

Try either of these:

=IF(Sheet1!$E$15="",NA(),Sheet1!E15)

=IF(Sheet1!$E$15="","",Sheet1!E15)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to convert list of formulas in text format to output value 6
ISBLANK function not working when cell is blank dut to function re 8
Graphing 0 values from blank cells 7
Excel VBA 1
linked cells show "0" 1
If statement that outputs specific text if cell is not null 2
Excel Need Countifs Formula Help 0
inserting a null value 3

Top