Excel IF THEN Statement-complex

[kcompton]

Hello I am trying to write a formula for the following table example that would return result options in Column C depending on the data entered in columns A and B:

IF A1=0 and B1>=133, then C1=ON if B1<133, then C1=NO;
IF A1=1 and B1>=153, then C1=ON if B1<153, then C1=NO;
If A1=2 and B1>=166, then C1=ON if B1<166, then C1=NO;
IF A1=3 and B1>=179, then C1=ON if B1<179, then C1=NO;
IF A1 is Blank, then C1= RN
(then the formula would be copied down to C2, C3, etc

Level (A)	Score (B)	Results (C)
0	153	ON
0	120	NO
0		RN
1	145	NO
1	155	ON
1	153	ON
2	167	ON
2		RN
2	165	NO
3	179	ON
3	166	NO
3	195	ON

<tbody>
</tbody>

Thank you for any help you can provide

 

[Rick Rothstein]

Give this formula a try...

=IF(B1="","RN",IF(B1>=CHOOSE(A1+1,133,153,166,179),"ON","NO") )

 

[kcompton]

Thank you for the quick reply! This works!