Top Posters
Since Sunday
11
4
4
m
4
l
3
M
3
j
3
P
3
t
3
S
3
c
3
r
3
 12 New Topic

# Which function calculates the Reduction in C2 to be filled through the rest of the reduction column ...

wrote...
Posts: 421
Rep: 0 0
4 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

Edition: 1st
Authors:
17 Replies
Replies
Answer verified by a subject expert
anicidanicid
wrote...
Top Poster
Posts: 694
4 years ago

### Related Topics

wrote...
3 years ago
 thank you
wrote...
3 years ago
 thank you
wrote...
3 years ago
 thank you
wrote...
3 years ago
 Thank you
wrote...
7 months ago
 Thank you so much
wrote...
7 months ago
 thank you
wrote...
4 months ago
 TY :)
wrote...
3 months ago
 Thanks
wrote...
3 months ago
 Thx
wrote...
3 months ago
 TY :)
wrote...
3 months ago
 Thx
wrote...
3 months ago
 Thank you so muchPost Merge: 3 months ago
 12 New Topic