Hi All

I have a brain teaser.

I'm trying to make a formula which says :

If E2 starts with "C" and J2 equals 1 or 11 , then put 5 , otherwise put
J2
If E2 starts with "C" and J2 equals 2 , then put 6 , otherwise put J2


Can someone help with this?

I'm grateful for any advice.



I tried this :

=IF(COUNTIF(E2,"C*")0,J2,IF(J2=2,6,IF(OR(J2=1,J2= 11),5,J2)))

and this

=IF(LEFT(E2)="C",J2,IF(J2=2,6,IF(OR(J2=1,J2=11),5, J2)))

but neither give correct results :(



Best Wishes