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