Question

Enter an IFS statement to provide the certification grade based upon score (use the<=in your formula) include the IFERROR message as a error catch

Answer 1

=IFERROR(IF(score<=100,"A",IF(score<=90,"B",IF(score<=80,"C",IF(score<=70,"D",IF(score<=60,"F","Invalid"))))),"Invalid")