Forum Discussion
Formula assistance requested
=IF(AND(O2=“Real Deal”,P2=“Conditional Approved”,CR2=“”,NOT(ISBLANK(AB2))*S2>(TODAY()+16)),”YES”,”NO”) I need the formula above to pick up either conditional approved or approved w/condition in co...
=IF(
AND(
O2=“Real Deal”,
OR(P2=“Conditional Approved”,P2="Approved w/condition"),
CR2=“”,
NOT(ISBLANK(AB2))*S2>(TODAY()+16)
),
”YES”,”NO”)
I'd strongly recommend that P2 use data validation so that only one of those answers is accepted, since they mean the same thing. Don't do it based on trusting people to enter the right words, spelled and punctuated precisely. Then you also wouldn't need the OR
Thank you so much for your help! That works perfectly