Hi,

I have a problem in providing the right formula to perform a subtraction between two cells that contain themselves a formula.
Let's make an example:

CELL A1 = 95 (95 is the result of a formula)
CELL A2 = NOTHING (I mean that this cell contains a formula whose result is not existing because there are no values in the data source, normally I should see a DIV error but I used the IF(ISERROR,"",) etc. therefore the cell A2 looks empty.)

Now, when I put the formula = A1-A2 instead of getting 95 a get nothing, therefore the final resul is wrong.

Can anybody explain me why I cannot subtract 95 - nothing? It should give me 95 anyhow, or not.....

Thank you
Alex