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

Ever get confused when calculating the percentage of a number? What is 55.5% of 123.45? Do you multiply or divide by 100? Does precedence make a difference?

This video shows a simple and easy to use formula in Excel, starting out with easy to understand figures and ending with more awkward numbers.

[veronicablanco]

Thank you! It was hard to find an explanation where we want to calculate a specific percentage of a cell. Your video should be number one on the list of searches!

[michelledohertyphotomedia]

Thank you for a clear, short video without any guff or stuffing about. Straight into it, double-checked— exactly what I wanted. I’m on my way with my workbook. Thank you.

[andrewvalentine]

OH MY GAWD! I LOVE YOU! Thank you so much, and thanks for the formula. You sir, have saved my behind with this formula instead of just using decimals like the guy above.

[reemanawaz]

You saved me from working whole night manually calculating percentage. Thank you so much for the help.

[jefirealtor]

After an hour I found you video... THANK YOU!!!!

[kevindeguzman]

Hi Sir — I am new to excel and need to prepare a report. This video is exactly what I need and it’s very handy! I tried it to my actual report and it worked perfectly! Thank you very much, I already hit the subscribed button, by the way. 🙂

[cocobutterkid]

amazing and straight to the point thank you!

[pricilla]

Thank you so much for making it so simple to follow and understand!

[DebbyDoesDesktop]

Thank you for this very simple solution for my big problem

[SamiTheAnxiousBean]

Striaght to the point
Useful in all situations instead of only in that spesific example
And other tutorials easy to understand aswell


Great job dude and thank you

[robertreeves]

thank you so much you helped so much and your accent is cool

[damita]

Good day! Can I ask you a question? why you always diveded by 100 I just wondering if just divided by 100 or there's another number can be replace at 100? thanks

[zenmovement]

made so easy thanks I was really struggling

[kraigi]

I'm trying to divide a grand total of money across various expenses by applying a percentage to each one. I can't seem to get the SUM function to carry over the £ symbol which is making the final amounts difficult to decipher.

[hurricanejimmyc]

Thank you so much this helped me a lot :D

[Thomassantucci]

but how do I break it down to other percentages using the same number

[poolstudio]

thank you... i was pulling my hair out until i found this

[Mahtabzamani]

Hi, Thank you very much for the brilliant video and explanation. I just have one question, Do I need to make columns just like you have done? or can i use the colums that I have ? also I was wondering if for eg. 45, 5% is a correct format of entering 45.5% in a cell?

[zegitalacademy]

keep it up, great tutorial, but what about if i have more than one value x the percentage divided by 100, how do i make it work?

[MegaMissfitz]

Morning sweet cheeks! At this point in time im 80% positive 😤😤😤