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

Dealing with the error: unable to filter on excel hc home school 0
Drop down list control value in vba 2
need help in fine-tuning a formula that removes blank cells in a column range 3
Word macro that can call cells out of Excel for a find and replace 0
Embed the same Excel multiple times 0
Graphing 0 values from blank cells 7
Need to convert list of formulas in text format to output value 6
VLOOKUP returning #N/A result 2

Top