Get instant live expert help on if left excel

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

=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