The complete formula that corresponds to the flowchart in the accompanying figure is _____.
A) =IF([Perf Rating]=2,2500,IF([Perf Rating]=1,2500,7500))
B) =AND([Perf Rating]=2,2500,AND([Perf Rating]=1,2500,7500))
C) =IF([Perf Rating]=1,0,IF([Perf Rating]=2,2500,7500))
D) =AND([Perf Rating]=1,2500,AND([Perf Rating]=2,0,7500))

Question

The complete formula that corresponds to the flowchart in the accompanying figure is _____.
A) =IF([Perf Rating]=2,2500,IF([Perf Rating]=1,2500,7500)) 
B) =AND([Perf Rating]=2,2500,AND([Perf Rating]=1,2500,7500)) 
C) =IF([Perf Rating]=1,0,IF([Perf Rating]=2,2500,7500)) 
D) =AND([Perf Rating]=1,2500,AND([Perf Rating]=2,0,7500))

Quizplus · Accepted Answer

The formula uses nested IF statements to check the value of the "Perf Rating" column. If the value is 1, the result is 0. If the value is 2, the result is 2500. If the value is anything else, the result is 7500. This matches the functionality of the flowchart in the accompanying figure.

The Complete Formula That Corresponds to the Flowchart in the Accompanying