The complete formula that corresponds to the flowchart in the accompanying figure is ____.
A) =IF([Pay Grade]=2,2500,IF([Pay Grade]=1,5000,7500))
B) =AND([Pay Grade]=2,2500,AND([Pay Grade]=1,5000,7500))
C) =IF([Pay Grade]=1,2500,IF([Pay Grade]=2,5000,7500))
D) =AND([Pay Grade]=1,2500,AND([Pay Grade]=2,5000,7500))

Question

Quizplus · Accepted Answer

The flowchart provides a simple if-else condition for three Pay Grades. If the [Pay Grade] is 1, the output is 2500, if it is 2, the output is 5000, and if it is anything else, the output is 7500. The corresponding formula for this structure is:
=IF([Pay Grade]=1,2500,IF([Pay Grade]=2,5000,7500))
Hence, the correct option is C.

The Complete Formula That Corresponds to the Flowchart in the Accompanying