Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can IF function return an empty cell? (not "") | Excel Worksheet Functions | |||
Disabling "wrap text" neuters alt-return line feeds within cell | Excel Discussion (Misc queries) | |||
Excel: can "go to adjacent empty cell" double-click be disabled? | Excel Discussion (Misc queries) | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
a formula that leaves cell "empty"? | Excel Worksheet Functions |