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 column P. How can I change it to do either or
2 Replies
=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
