Biology Forums - Study Force

Science-Related Homework Help Computer Studies Topic started by: David_DiSanto on Nov 17, 2017



Title: Which function calculates the Reduction in C2 to be filled through the rest of the reduction column ...
Post by: David_DiSanto on Nov 17, 2017
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)))


Title: Re: Which function calculates the Reduction in C2 to be filled through the rest of the reduction ...
Post by: anicid on Nov 17, 2017
Content hidden


Title: Re: Which function calculates the Reduction in C2 to be filled through the rest of the reduction ...
Post by: dixidooda on Mar 28, 2018
thank you


Title: Re: Which function calculates the Reduction in C2 to be filled through the rest of the reduction ...
Post by: nasflk on Mar 30, 2018
thank you


Title: Re: Which function calculates the Reduction in C2 to be filled through the rest of the reduction ...
Post by: sfdahskj on Mar 30, 2018
thank you


Title: Re: Which function calculates the Reduction in C2 to be filled through the rest of the reduction ...
Post by: noles24 on Mar 30, 2018
Thank you


Title: Re: Which function calculates the Reduction in C2 to be filled through the rest of the reduction col
Post by: TopFinesser on Apr 19, 2021
thank you