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

[TABLE="class: grid, width: 250"]
<tbody>[TR]
[TD]Level (A)[/TD]
[TD]Score (B)[/TD]
[TD]Results (C)[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]153[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]120[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD][/TD]
[TD]RN[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]145[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]155[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]153[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]167[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD]RN[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]165[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]179[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]166[/TD]
[TD]NO[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]195[/TD]
[TD]ON[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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!