Formulation

W

Windrick Smith

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
 
J

J.E. McGimpsey

One way would be to slightly modify my previous answer:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top