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

Nick Ruiz asked Feb 9, 2023

443,416 views

11 votes

Nick Ruiz asked Feb 9, 2023

3.1k points

Your comment on this question:

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Email me at this address if my answer is selected or commented on:Email me if my answer is selected or commented on

Privacy: Your email address will only be used for sending these notifications.

9 votes

Answer:

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

3.1k points

Email me at this address if a comment is added after mine:Email me if a comment is added after mine

Privacy: Your email address will only be used for sending these notifications.

Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

1.6m questions

2.0m answers