Top Posters
Since Sunday
11
4
4
m
4
l
3
M
3
j
3
P
3
t
3
S
3
c
3
r
3
New Topic  
David_DiSanto David_DiSanto
wrote...
Posts: 421
Rep: 0 0
4 years ago
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   B   C
1   Level   Price   Reduction
2   Silver   125   ?
3   Gold   125   
4   Platinum   125   

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

Exploring Microsoft Office Excel 2016 Comprehensive


Edition: 1st
Authors:
Read 1472 times
17 Replies
Replies
Answer verified by a subject expert
anicidanicid
wrote...
Top Poster
Posts: 694
4 years ago
Sign in or Sign up in seconds to unlock everything for free
More questions for this book are available here
A

Related Topics

wrote...
3 years ago
thank you
wrote...
3 years ago
thank you
wrote...
3 years ago
thank you
wrote...
3 years ago
Thank you
wrote...
7 months ago
Thank you so much
wrote...
7 months ago
thank you
wrote...
4 months ago
TY :)
wrote...
3 months ago
Thanks
wrote...
3 months ago
Thx
wrote...
3 months ago
TY :)
wrote...
3 months ago
Thx
wrote...
3 months ago
Thank you so much
Post Merge: 3 months ago

  New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  398 People Browsing
 1050 Signed Up Today
Your Opinion
Which of the following is the best resource to supplement your studies:
Votes: 158

Related Images
 623
 125
 167