Simplify Formula

Hello, can someone please help me to simplify this formula

=IF($B4="A";AND($C4>=$I$4;$C4<=$J$4);IF($B4="B";AND($C4>=$I$5;$C4<=$J$5);IF($B4="C";AND($C4>=$I$6;$C4<=$J$6);IF($B4="D";AND($C4>=$I$7;$C4<=$J$7)))))

=IF($B4="A";NOT($C4>=$I$4);IF($B4="B";NOT($C4>=$I$5);IF($B4="C";NOT($C4>=$I$6);IF($B4="D";NOT($C4>=$I$7)))))

=IF($B4="A";NOT($C4<=$J$4);IF($B4="B";NOT($C4<=$J$5);IF($B4="C";NOT($C4<=$J$6);IF($B4="D";NOT($C4<=$J$7)))))

The data should look like this

excel.jpg

The purpose of the formula is to find which is "between" "under" and "above" certain range of number from certain subject

so

Formula:

Please Login or Register  to view this content.