Top Posters
Since Sunday
r
4
L
4
3
d
3
M
3
l
3
V
3
s
3
d
3
a
3
g
3
j
3
New Topic  
David_DiSanto David_DiSanto
wrote...
Posts: 421
Rep: 0 0
6 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

Exploring Microsoft Office Excel 2016 Comprehensive


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

Related Topics

wrote...
6 years ago
thank you
wrote...
6 years ago
thank you
wrote...
6 years ago
thank you
wrote...
6 years ago
Thank you
wrote...
3 years ago
thank you
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1441 People Browsing
Related Images
  
 1073
  
 164
  
 241