Here's what I'm trying to do:
If O2 = yes AND U2 is grant then write "Agree? OR If O2 is NO and U2 is deny then write ?Disagree?
I made an AND that checks for "Agree", but couldn't get it any further than that.
=IF(AND(O2="YES",U2="GRANT"),"AGREE","DISAGREE")
This didn't do it:
=IF(OR(AND(O2="YES",U2="GRANT"),"AGREE"), IF(OR(AND(O2="NO",U2="DENY"),"DISAGREE")))
I'd also like 5to have it stay blank if neither condition is met. Is this possible?
Thanks!
Bookmarks