Top Posters
Since Sunday
g
3
3
2
J
2
p
2
m
2
h
2
s
2
r
2
d
2
l
2
a
2
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 1902 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
  1105 People Browsing
 114 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 1880
  
 287
  
 304
Your Opinion
Which country would you like to visit for its food?
Votes: 204
Previous poll results: What's your favorite math subject?