Hi. Im trying to make a document which calculates the percentage totals by allowing the user to enter any percentage into cell C23 (5%, 10%, 12%) and return the difference in cell D23. For example, B23 is the sum of B8 & B9. Based on customer ranking, they are entitled to receive 5%, 10%, or 12% back in "store dollars". I'd like for our internal users to be able to plug in the percentage for the specific customer in to cell C23 and excel will calculate the correct amount and return it to cell D23.
For the example shown on the attached, im looking for 5% of $107.00 ($5.35) to return in cell D23. How can i accomplish this?
Can you please add an example worksheet so we do not have to recreate?
Purfleet
apologies. I did upload the document originally, but am not sure what happened. Please find it here. Thanks so much!
Hi Valerie
We just need 5% of b23 ? so put =B23*C23 in D23
Not sure if you are aware but b17 is not including b8 and if order subtotal and MMB & PGB are all going to be the same i reference them against each other.
Purfleet
