ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   percentile (https://www.excelbanter.com/excel-worksheet-functions/9611-percentile.html)

Blessingspoint

percentile
 
What would I use to get a % 0f 4 different numbers
Example: C1=% of a1, a4, b4, b6

Bernard Liengme

Needs clarification

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Blessingspoint" wrote in message
...
What would I use to get a % 0f 4 different numbers
Example: C1=% of a1, a4, b4, b6




Michael R Middleton

Maybe, in another cell, enter =A1/SUM(A1,A4,B4,B6), and format that cell as
%. Etc.

(By the way, that would be a percentage, not a percentile.)

- Mike

www.mikemiddleton.com

"Blessingspoint" wrote in message
...
What would I use to get a % 0f 4 different numbers
Example: C1=% of a1, a4, b4, b6





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

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