Print

Training >> Browse Articles >> Applications

+50

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:

=(B2-A2)/A2

Description:

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

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