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" <[email protected]> wrote in message
news:[email protected]...
> 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"
<[email protected]> 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