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
|