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 1903 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
  1097 People Browsing
 118 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 327
  
 367
  
 248
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 352
Previous poll results: Do you believe in global warming?