Hi Spike,

This is not a complete formula.
An IF should have a TRUE part and a FALSe part, like in:
=IF(Condition, TrueValue,FalseValue)
Your formula has been corrupted one way or another. It should read something
like
=IF(ABS(I82-I130)Tolerance_Fund,I79,I82)
But why do you say it gives a numeric result? What? and what, again, are the
input values?
Do you have any idea what the formula is *supposed* to do?

--
Kind regards,

Niek Otten




"Spike" wrote in message
...
Formula is =IF(ABS(I82-I130)Tolerance_Fund,#VALUE!+I82)

This actually produces a numeric result
--
with kind regards

Spike


"Niek Otten" wrote:

And the value of the input cells?

--
Kind regards,

Niek Otten

"Bob Phillips" wrote in message
...
Can you post the formula?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Spike" wrote in message
...
I have come across a formula with #VALUE actually in the formula as
opposed
to the result. What does this mean, if it is correct why would
someone
code
it into the formula and what does it do as the result is a number and
not
#REF or #VALUE.

Any advices will be gratefully received
--
with kind regards

Spike