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