Multiple IF AND statements including LEFT

willow1985

Well-known Member
Joined
Jul 24, 2019
Messages
515
Office Version
2019
Platform
Windows
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
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,780
That's the beauty of this forum! One question can help many people!

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

Watch MrExcel Video

Forum statistics

Threads
1,099,684
Messages
5,470,120
Members
406,681
Latest member
sachinmasurkar

This Week's Hot Topics

Top