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.