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