how can I convert a number to a percentage?

GMartin
GMartin used Ask the Experts™
on
Hello and Good Afternoon Everyone,

           This question is similar but not exactly like the one I have currently open.  Basically, I wish to know how to convert a number to a percentage.  The number of interest is total deductions.   To simplify my question here is a condensed hypothetical overview.  Gross Amount: $1,924.70   Total Personal Deductions: $424.05  Net Amount:  $1,500.65.

           If more information is needed, please feel free to let me know and it will be given.

           Thank you

           George

...
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Business Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018
Commented:
Divide Deductions (424.05) by Gross (1924.60) and multiply the result by 100.
To get a percentage you need a number and a base. It is unclear what they are in your question
Ecamples
In your case I think your number you want is 'Total personal deduction'
What is your base amount? It could be "gross amount", or "net amount"
-
you could use
% = 425.05/1924.70
or
% = 425.05/1500.65

take your pick
Joe WinogradDeveloper
Fellow 2017
Most Valuable Expert 2018
Commented:
Hi George,

The general formula is:

percentage=100x(number/total)

In your examples, the Personal Deductions are 22.03% of the Gross Amount, calculated by:

100x(424.05/1924.70)

Similarly, the Personal Deductions are 28.26% of the Net Amount, calculated by:

100x(424.05/1500.65)

Regards, Joe
Expert Spotlight: Joe Anderson (DatabaseMX)

We’ve posted a new Expert Spotlight!  Joe Anderson (DatabaseMX) has been on Experts Exchange since 2006. Learn more about this database architect, guitar aficionado, and Microsoft MVP.

Author

Commented:
Thank you, everyone, for answering my question.   The formula provided along with its breakdown certainly did make sense.  

George
JohnBusiness Consultant (Owner)
Most Valuable Expert 2012
Expert of the Year 2018

Commented:
You are very welcome and I was pleased to help you.
Joe WinogradDeveloper
Fellow 2017
Most Valuable Expert 2018

Commented:
You're welcome, George, always happy to try to help you. Regards, Joe

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial