That's ok. I was just kidding anyway. My response was the first one.
Maybe it was too quick. Anyway, it was the same as the others and you got
the correct answer...that's what's important. Good luck on your project.

Regards,
Paul


"Pat" .(donotspam) wrote in message
...
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