Top Posters
Since Sunday
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
r
4
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 1904 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
  1265 People Browsing
 116 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 76
  
 30
  
 1602
Your Opinion
Do you believe in global warming?
Votes: 370
Previous poll results: What percentage of nature vs. nurture dictates human intelligence?