Solved

Which Function Calculates the Reduction in C2 to Be Filled

Question 14

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

Q5: If 9/3/2021 is the contents of B3,

Q6: A(n)_is a matrix that provides the results

Q12: Match each of the following functions to

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

Q42: When formated as a date, the results

Q44: A NOT function reverses the truth of

Q54: The EOMONTH function returns the last day

Q58: You can nest AND, OR and NOT

Q62: The _ function returns the position of

Q82: What type of match would the following