IF function: Reference cells - Value vs Formula

[Guest]

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?

 

[Niek Otten]

You'll have to provide some more details to get useful help.
What are the formulas? What are the values of the precedent cells? What
result did you expect and what did you get instead? What do you mean if you
say "Doesn't work"?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

Post your formula and post the formula in the cell you are checking that does
not work, it's impossible to know otherwise except that it should work.

Regards,

Peo Sjoblom

 

[Ron Rosenfeld]

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