IF function: Reference cells - Value vs Formula
 

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?
--
News Gal

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

"Newsgal" wrote in message
...
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?
--
News Gal

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

"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?
--
News Gal

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