Solved

Which Function Calculates the Reduction in C2 to Be Filled

Question 16

Multiple Choice

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%? 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) ) )


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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Q11: The real functionality of MATCH and INDEX

Q12: A(n)_ is a schedule that calculates the

Q13: The _ function calculates the total number

Q14: Match each of the following functions to

Q15: NPER calculates the periodic interest rate of

Q17: Why would you nest MATCH in an

Q18: A(n)_ is a schedule that calculates the

Q19: The criteria range must contain _ at

Q20: Match each of the following terms to

Q21: Advanced filtering will not copy results to