ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Percentage of a number (https://www.excelbanter.com/excel-discussion-misc-queries/23069-percentage-number.html)

stevel

Percentage of a number
 
Good afternoon,

I have a percentage question. I am trying to find out how to create a
formula which will tell me what percent one number is to another. Basically
what percent of the number 25, 110, 30 etc... make up 330. I have about 6
numbers and want to know what is the percentage for each number. Thanks

Fred Smith

Divide one by the other, format as percent. For example =3/4 results in 75%,
meaning that 3 is 75%of 4.

--
Regards,
Fred
Please reply to newsgroup, not e-mail


"stevel" wrote in message
...
Good afternoon,

I have a percentage question. I am trying to find out how to create a
formula which will tell me what percent one number is to another.
Basically
what percent of the number 25, 110, 30 etc... make up 330. I have about 6
numbers and want to know what is the percentage for each number. Thanks





All times are GMT +1. The time now is 12:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com