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
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
David_DiSanto David_DiSanto
wrote...
Go to Answer
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 1939 times
6 Replies
Replies
Answer verified by a subject expert
anicidanicid
wrote...
#1
Top Poster
Posts: 694
Rep: 32 0
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...
#2
6 years ago
thank you
wrote...
#3
6 years ago
thank you
wrote...
#4
6 years ago
thank you
wrote...
#5
6 years ago
Thank you
wrote...
#6
3 years ago
thank you
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1873 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Related Images
  
 470
  
 281
  
 297
Your Opinion
What's your favorite coffee beverage?
Votes: 303
Previous poll results: Which industry do you think artificial intelligence (AI) will impact the most?