IF(OR Formula only producing a False response

[cprice4407]

I can't seem to get this formula to produce the True value. It looks like it should work. Any suggestions to condense the formula are another way to get the True=1 and False=.80 would be much appreciated

=IF(OR(A3="5",A3="6",A3="7",A3="8",A3="9",A3="10",A3="11",A3="19",A3="20",A3="21",A3="22",A3="23",A3="24",A3="25",A3="26",A3="27",A3="31",A3="32",A3="34",A3="35",A3="36",A3="37",A3="38"),"1",".80")

[mehmetcik]

Wow

Please Login or Register  to view this content.

[cprice4407]

Thanks for the help. Still returns false response.

[mehmetcik]

Please Login or Register  to view this content.

[cprice4407]

Excellent. Thank you very much.

[Saba Sabaratnam]

Please try this one

=IF(ISNA(INDEX({5,6,7,8,9,10,11,19,20,21,22,23,24,25,26,27,31,32,34,35,36,37,38},MATCH(A2,{5,6,7,8,9,10,11,19,20,21,22,23,24,25,26,27,31,32,34,35,36,37,38},0)))=FALSE,80,1)

[cprice4407]

This also worked. Thanks! Would you have a way to add a test to make a 0 value = 0 on this formula?

[Saba Sabaratnam]

I added one more if condition to test 0 value as shown below.

=IF(A2=0,0,IF(ISNA(INDEX({5,6,7,8,9,10,11,19,20,21,22,23,24,25,26,27,31,32,34,35,36,37,38},MATCH(A2,{5,6,7,8,9,10,11,19,20,21,22,23,24,25,26,27,31,32,34,35,36,37,38},0)))=FALSE,80,1))

[cprice4407]

Work with a minor change.. Thank you again for your help!

=IF(A2=0,0,(IF(ISNA(INDEX({4,5,6,7,8,9,10,11,19,20,21,22,23,24,25,26,27,31,32,34,35,36,37,38},MATCH(A2,{4,5,6,7,8,9,10,11,19,20,21,22,23,24,25,26,27,31,32,34,35,36,37,38},0)))=FALSE,1,0.8)))