Return an empty cell instead of "VALUE"
 

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

=IF(A9870,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?

Return an empty cell instead of "VALUE"
 

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.



rhhince wrote:

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

=IF(A9870,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?

--

Dave Peterson

Return an empty cell instead of "VALUE"
 

=IF(ISERROR(ABS(A1-B1)*10000),"",ABS(A1-B1)*10000)


"rhhince" wrote:

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

=IF(A9870,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?