“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

=IF(or(LEFT(C4,1)<>"64",(left(c4,1)<>"65"),0,IF(AND(OR(LEFT(C4,2)="64",LEFT(C4,2)="65"),D4=0,E4=0,LEFT(F4,1)="9",G4="I"),0,1)) I need a solution to say that if c4 is different then 64 or 65 the result should be 0 otherwise if c4 equals 64 or 65 and d4=0 and e4=0 and left f4 = 9 and G4=I it should be 0 if not 1

Solved by S. E. in 25 mins

In Microsoft Excel, if you click on a number to the left of Column A, it will?

Solved by K. Q. in 17 mins

Add IF formula to current LEFT/FIND formula

Solved by A. B. in 23 mins

should this work? IF((LEFT(x7,2)= "14","COPD","NEONATE"))

Solved by Z. Y. in 17 mins

I need to nest IF and LEFT I have c2=(left(c2,po) for the logical test part but I keep getting an invalid notification

Solved by D. U. in 22 mins