Monday, August 24, 2015

How To... Calculate the Percentage of a Number in Excel 2013

I've always been confused when calculating percentages. If I want to determine what is 15% of 456, I have to always check if I am using the right method to calculate. Sometimes I have to do a simple calculation first - eg, use a formula to calculate what is 15% of 100 - if I get a result of 15 I know I am right. In Excel I use formulas to do the same, but am always wondering things like should I divide or multiply by 100? Where should the numbers go?

So I decided to make a video to remind me how it is done, and hope that this will also help other "percent" challenged folks out there in YouTube land. Here is the video:

No comments:

Post a Comment