Multiple IF AND statements including LEFT

[willow1985]

Hello,

Quick question. I am looking to do a multiple IF AND statement including LEFT. The below formula gives me a #VALUE error so I know I am doing it incorrectly:

=IF(AND(C2="Blue",(LEFT(D2,1)="C"),"250",""),IF(AND(C2="Blue",LEFT(D2,1)="B"),250,""))

C2 has to be Blue AND D2 has to start with a B or a C to return a 250, otherwise blank.

Hope someone can shed some light on this.

Thank you

Carla

 

[Eric W]

Try:

=IF(AND(C2="Blue",OR(LEFT(D2)={"B","C"})),250,"")

 

[willow1985]

This is perfect! Thank you

 

[Eric W]

Happy to help!

 

[J0hnJ]

Eric,

Thank you! this formula helped me also!

John

 

[Eric W]

That's the beauty of this forum! One question can help many people!

Thanks for stopping by, and thanks for the feedback! ?