Creating an IF / AND statement
Sorry PCLive . . . I don't see your answer . . . but yes Thank you! ;o
--
Thanks, Pat
"PCLIVE" wrote:
What am I? Chopped Liver?!!!
You're welcome anyway.
"Pat" .(donotspam) wrote in message
...
Thank you TOM & PETE!!
It worked perfect.
Have an awesome day. ;)
--
Thanks, Pat
"Pete McCosh" wrote:
It's the structure of the AND part that's causing the problem:
=IF(AND( B2=3, C2=1),"YES","Not Yet")
Cheers, Pete.
"Pat" wrote:
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
|