Jim

Your solution works fine as also Pascals'

Thank you!
Alex

"Jim Rech" wrote:

You can use the N function in your situation:

=A1-N(A2)

--
Jim Rech
Excel MVP
"Metallo" wrote in message
...
| 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
|