If and then statement needed..

[Mrs. T]

I'm having a heck of a time figuring out a statement....

I need to know:
if cell B4 is a NO, then 0
if cell B4 is a YES and cell C4 is a YES, then 10
if cell b4 is a YES and cell C4 is a NO, then 5

This is what I have, but it's coming up false:
=IF(B5="NO",0,IF(B5="YES",IF(AND(B5="YES",C5="YES"),$L$11,AND(B5="NO",C5="NO"))))

What am I doing wrong?

 

[Fluff]

How about
=IF(B4="NO",0,IF(AND(B4="YES",C4="YES"),10,IF(AND(B4="YES",C4="NO"),5,"")))

 

[DanteAmor]

Just another way:

=LOOKUP(B4&C4,{"No","YesNo","YesYes"},{0,5,10})

 

[Eric W]

Or, if those are the only values you can have in B4 and C4:

=(B4="YES")*IF(C4="YES",10,5)

 

[Mrs. T]

This worked!

Thanks so much everyone!!

 

[Fluff]

Glad we could help & thanks for the feedback

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.

 

[Mrs. T]

Hello (again)

Looking for another if/then/and statement...hoping you guys could help again!

G5 = a person's name
H5 = their lodging choice (there are 3 choices - Junior Sat ($90), Junior Fri & Sat ($120) or Brownie Saturday ($90)

I would like the cell to look at G5 and if there's nothing in there, to be Zero. If there's a name in G5, then I need it to look at the choice it gave in H5 to result in a price.

 

[Fluff]

As this is a totally different question, you will need to start a new thread.
Thanks