Return an empty cell instead of "VALUE"

R

rhhince

I am trying to figure out how to return an empty cell with the
following formula:

=IF(A987>0,ABS(A987-B987)*10000,"")

It turns out that if A987<0, I get "VALUE" as an answer instead of
leaving the cell blank, because understandably 0-0=0. How could I
touch up the formula to leave the cell empty?
 
D

Dave Peterson

It's not that A987 is less than 0. That won't cause any trouble with your
formula.

Look at A987 and B987 and make sure that they are both numbers.

Select each cell and format each as General (or anything but Text).
Then select each cell and hit F2 followed by enter to make sure that excel sees
those cells as numbers.
 

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

Excel formula, sum the value cell and if empty cell left blank 0
How use value of a cell without turning #VALUE! 2
return blank cell if condition met 2
AVG or Return 1 value from either of 2 cells if one is blank 8
simple sum unless blank 5
If function across sheets prints value of cell 4
Empty cell in vlookup 9
Excel If statement that is supposed to return a "" instead returns a 0 1

Top