Formulation

C

crxman

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%. I don’t know how to make this work. Please help
 

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