On Tue, 24 May 2005 10:56:04 -0700, "Newsgal"
wrote:

Spreadsheet has IF Function that refers to a cell with a formula instead of a
hard entered value. Doesn't work when formula is in cell. Works when formula
is overridden by hard entering value even when hard entered number matches
number as result of formula. Can this be fixed?

It is likely that your formula is returning a result that appears valid but is
not. One common error is to have your formula return a TEXT string that looks
like a number; and your IF statement is checking for a true number.


--ron