Register
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
166k views
4 votes
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

User Mike Chaliy
by
3.9k points

1 Answer

3 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")

User Pugmarx
by
4.4k points
Ask a Question
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.

4.5m questions

5.9m answers

Other Questions

Assume you have created a mechanical arm that can hold a pen. The arm can perform the following tasks: • Lower the pen to a piece of paper. • Raise the pen from the paper. • Move the pen 1 inch along a
Drag each connector name to match the connector type shown.
What is the maximum throughput of a homogeneous pipeline in which four processors each handle one million instructions per second and processing a data item requires 50, 60, 40, and 30 instructions, respectively?
What problem does chlorofluorocarbon (CFC) create? a. it causes lead poisoning b.it causes great damage to the ozone layer c. it leaks into food as it cools the air and refrigerators d. it is responsible
33. (03.03 LC) Technologies are having a negative impact on businesses. (2 points) O True False I need help smh
Link Copied!