Training >> Browse Articles >> Applications


10 Excel Secrets Every Admin Should Know

AdminSecret and Richard Rinyai

8. Calculating Discounts

Have you ever wondered how to calculate discounts on certain products/services that you or your firm offers? One of my colleagues had this dilemma a few days ago.

I tried searching around for an answer on Google, but no luck. It kept providing me topics that weren’t relevant to the particular answer I was looking for. I then checked Excel’s help file and there it was.

Here is how to calculate the difference between two numbers as a percentage:

For example, your earnings are $2,342 in November and $2,500 in December. What is the percentage change in your earnings between these two months? To do this task, use the ABS function and the subtraction (-) and division (/) operators.

A = November earnings: 2342
B = December earnings: 2500

The formula for this is:



Divides the difference between the second and first numbers by the absolute value of the first number to get the percentage change (0.06746 or 6.75%)

And don’t forget to click the % icon to format it into a percentage.

AdminSecret School Finder

Save time in your search for a degree program. Use AdminSecret's School Finder to locate schools online and in your area.

* In the event that we cannot find a program from one of our partner schools that matches your specific area of interest, we may show schools with similar or unrelated programs.

Recent Activity

romanico received the quiz result of "21-50% correct: Good effort", about 2 years ago.
tmiller received the quiz result of "Satisfactory", about 2 years ago.
new2admin gave a thumbs down to The Article "6 Ways Finding a Dream Job Is Like Finding Your Soul Mate", about 2 years ago.
kinsh1987 received the quiz result of "Legal Secretary ", about 2 years ago.
LoraJ commented on: "Lora Coats", about 2 years ago.