On Mon, 22 Aug 2005 02:30:43 -0700, "Natalie Tarry" <Natalie
wrote:

Hello All
I have created a formula in one column that returns a value of 5 if a given
line entry is more than 5 years old.

What I want to do is then say " if (and((d35, b30),"Yes","")
What this does is if the entry is over 5 years old and there is a value
greater than 0 in cell b3, then give a value of "yes".

However since cell D3 contains a formula it does not work! If I were to
manually type in the values in Column D then it works ok.

Is there a function in Excel that says "if the result of the formula 5"
then ....??

thanks
Natalie

Your formula SHOULD work. The problem is likely that the result of the formula
in d3 is not exactly 5. (or that it is not a number).

What, exactly, is in D3?, B3?

What, exactly, do you see if you format D3, B3 as General?


--ron