Formula for cell E4 should be =ROUND(100*(E2-E3)/E2,2)Originally Posted by Sindril
Ok, I'm mathmatically challenged, but I love Excel an figure this should be pretty easy. Here is my problem.
List Price $46.98 (e2)
Net Cost $19.53 (e3)
How do I enter a calculation that will show me my discount percentage from my supplier? (e4)
I then need to be able to drag the formula to the end of the sheet. Discount percentages will be different for each product, but the List Price and Net Costs are present, so the calculation needs to take these differences into consideration so that I get the correct discount percentage for each item. Thank you!
Yeppers, I should have said F2 NOT E3:
Now it works just dandy! Except that it shows 5843.00. Can I ask one final question? How do I get it to put the decimal in the correct place, which in this case would make it 58.43? Again, thank you!
What have you got in F2 then? The problem with percentages is that it depends how you have the cell formatted. Really, the answer should be 58.43%, which means formatting cell E4 as a percentage, with 2 decimal places (go to Format, Cell, Number) and then the actual value of the cell should be 0.58. Test it by putting "=1*E4" in another cell. Depending on the format, you might need to remove the "100*" from the formula.
Last edited by ByTheCringe2; April 25th, 2006 at 05:31.
Okay, you are right. Once I changed the cell to number instead of % is shows me 58.43 which is exactly what I needed to see. I know it is a percentage and that's all that counts in my particular application.
Have an awesome day!
There are currently 1 users browsing this thread. (0 members and 1 guests)