 • 395K Members
• 8,078 Online
• 429K Conversations

# Calculating the percentage of two numbers

If I have the number 50 in one cell and 188 in the next cell and I need to know what percentage each one of those numbers are of 238.  What is the formula?

3 Replies
Highlighted

# RE: Calculating the percentage of two numbers

suppose a1 holds the value 50 and b1 the value 188. Then a2 (f.e.) should have the formula =a1/(a1+b1) and b2 =a2/(a1+b1)

# Re: RE: Calculating the percentage of two numbers

I think you meant to say B2 = B1/(A1+B1).

Cheers

Damien

# Re: RE: Calculating the percentage of two numbers

Correct!
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
\$cred = Get-Credential without asking for prompts in powershell
TejCGS in Office 365 on
6 Replies