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