Nesting LEFT into an OR formula

[Nanaia]

Cheers!
I'm trying to incorporate a LEFT function into the following formula so it will look at only the first two digits of CSV!J3 for the numbers 4,5,8,10,11.

=IF(OR(CSV!J3={4,5,8,10,11}),((0.1005*TAN((PI()/180)*(90-(CSV!Z3/2))))-(0.0693*SIN((PI()/180)*(90-CSV!Z3/2))))*2,0)

I tried

=IF(OR(LEFT(CSV!J3={4,5,8,10,11},2)),((0.1005*TAN((PI()/180)*(90-(CSV!Z3/2))))-(0.0693*SIN((PI()/180)*(90-CSV!Z3/2))))*2,0)
but I get a VALUE! error. Can anyone help me fix this?

 

[DanteAmor]

The left function returns a text, now you have to ask for a text
Try:


=IF(OR(LEFT(CSV!J3,2)={"04","05","08","10","11"}),((0.1005*TAN((PI()/180)*(90-(CSV!Z3/2))))-(0.0693*SIN((PI()/180)*(90-CSV!Z3/2))))*2,0)

or

=IF(OR(VALUE(LEFT(CSV!J3,2))={4,5,8,10,11}),((0.1005*TAN((PI()/180)*(90-(CSV!Z3/2))))-(0.0693*SIN((PI()/180)*(90-CSV!Z3/2))))*2,0)

 

[Yongle]

deleted

Better solution already provided

 

[Nanaia]

Fantastic! The second suggestion worked best. It recognized entries both with and without the extra fluff after the first two digits.
Thank you!

 

[Aladin Akyurek]

Try...

=IF(ISNUMBER(MATCH(LEFT(CSV!J3,2)+0),{4,5,8,10,11},0)),((0.1005*TAN((PI()/180)*(90-(CSV!Z3/2))))-(0.0693*SIN((PI()/180)*(90-CSV!Z3/2))))*2,0)

 

[DanteAmor]

Fantastic! The second suggestion worked best. It recognized entries both with and without the extra fluff after the first two digits.
Thank you!

I'm glad to help you. Thanks for the feedback.