Which function calculates the Reduction in C2 to be filled through the rest of the reduction column if silver members have a 5% discount,gold 10% and Platinum have 20%?

A)=IF(A2="Silver",B2*0.05,IF(A2="Gold",B2*0.1,B2*0.2))
B)=IF(A2="Silver",B2*0.1,B2*0.2)
C)=IF(A2="Silver" B2*0.05,OR(A2="Gold",B2*0.1,OR(B2*0.2))
D)==IF(A2="Silver",B2*0.05,IF(A2="Gold",Platinum=B2*0.1,B2*0.2)))

Question

Which function calculates the Reduction in C2 to be filled through the rest of the reduction column if silver members have a 5% discount,gold 10% and Platinum have 20%?

A)=IF(A2="Silver",B2*0.05,IF(A2="Gold",B2*0.1,B2*0.2)) 
B)=IF(A2="Silver",B2*0.1,B2*0.2) 
C)=IF(A2="Silver" B2*0.05,OR(A2="Gold",B2*0.1,OR(B2*0.2)) 
D)==IF(A2="Silver",B2*0.05,IF(A2="Gold",Platinum=B2*0.1,B2*0.2)))

Quizplus · Accepted Answer

The function uses nested IF statements to check the membership level (Silver, Gold, Platinum) and applies the respective discount percentage (5%, 10%, 20%) to the value in cell B2, which represents the total reduction needed in the column. This will calculate the reduction amount for each membership level correctly.

Which Function Calculates the Reduction in C2 to Be Filled