Hi,

The following formula in a cell retuns the #VALUE! error message. I have
tried using the formula auditing-evaluate formula. It shows the #VALUE!
message when it gets to the part about "ProcAP", but I do not understand why.
So I broke down the formula into the separate pieces and tested each part,
they all work independantly just fine. I am missing somthing, and would
appreciate any help you could offer.

The needed result is to look at a code in column B and based on a date in
either column Z or column AA determine if it is older than 30 days or 90 days
from todays date and either return what is in column B or add the text from
column B plus " <3 Months" or " < 1 Month".

The actual formula's are typed below:

Combined Formula:
=IF(AND(B3="PCard",Z3<(TODAY()-90)),B3,B3&" < 3
Months"),IF(AND(B3="ProcPUR",Z3<(TODAY()-90)),B3,B3&" < 3
Months"),IF(AND(B3="ProcAP",AA3<(TODAY()-30)),B3,B3&" < 1
Month"),IF(OR(B3="REC'ving",B3="FSC"),B3,"")

Separated parts of Formula:
=IF(AND(B3="PCard",Z3<(TODAY()-90)),"PCard",B3&" < 3 Months")
=IF(AND(B3="ProcPUR",Z3<(TODAY()-90)),"ProcPUR",B3&" < 3 Months")
=IF(AND(B3="ProcAP",AA3<(TODAY()-30)),B3,B3&" < 1 Month")
=IF(OR(B3="REC'ving",B3="FSC"),B3,"")

Column 3 contains either PCard, REC'ving, ProcPUR, ProcAP, or FSC
Column Z contains an Order Date ( approx 5 yr range through today's date)
Column AA contains a Received Date (approx 5 yr range through today's date)

Thank you for any solutions or guidance you can offer!

Linda