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...