I was also surprised but #REF! error value was found in VALUES and NOT in
formulas. But if you think it over, it's logical: the formula doesn't CONTAIN
the error value, it just returns it.

Stefi


€žLuke M€� ezt Ã*rta:

I believe you meant "Look in: formulas", as the value of OP's formula will
not be the error.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Stefi" wrote:

EditFindEnter #REF! in the Find what fieldOptionsLook in: Select
Values!Click Find All!

Regards,
Stefi



€žBrotherharry€� ezt Ã*rta:

I have a formula in a spreadie used by a variety of people that
occasionally becomes corrupted due to cells being deleted improperly
and the cell references being replaced by #ref!.
The formula still generates a valid result, but it's the wrong one
because it's not looking at the correct data because of the corrupted
references.
e.g.
=IF((ISNUMBER(#REF!)),#REF!,(IF((R3134=0),N3134,N3 134/R3134)))

This means that what superficially appears to be a functioning
spreadie actually has flaws as the formulas aren't generating correct
results. What I need is a quick way to spot formulas that contain
#REF.

The FIND function won't work as presumably it's only looking in the
result of a formula, not the actual formula itself.