Excel (Grading)

=IFERROR(IF(OR(ISBLANK($A4),ISBLANK($B4),ISBLANK($D4)),"--",IF(AND($A4>=$B4,$A4<=$D4),"In Range",IF($A4<$B4,"below",IF($A4>$D4,"Above",)))),"N/A")