Formulation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I write this, I have a spreadsheet and in column C I have a dollar amount. In column D I want Microsoft excel to take that dollar amount from column C and if that amount is 1.00-10.00 I want it to multiply by 100%, and if the amount is 10.01 to 25.00, I want it to multiply the amount by 60%, and if the amount is over 25.00 I want that amount to be multiply by 40%. But I also want excel to do is add the original amount from C plus the 100%, 60% or the 40% and put that amount in D, I don’t know how to make this work. Please help
 
One way would be to slightly modify my previous answer:

D1: =C1*(2-0.4*(C1>10)-0.2*(C1>25))
 
Back
Top