Creating an IF / AND statement
Try this:
=IF(AND(B2=3,C2=1),"YES","Not Yet")
HTH,
Paul
"Pat" .(donotspam) wrote in message
...
Is there a way to create an if statment that involves two different cells;
ie "IF B2=3, AND C2=1, YES, NOT YET"
I've tried: =IF(B2=3,(AND(C2=1,"YES","Not yet")))
but it returns a #Value! error.
Thank you!
--
Thanks, Pat
|