Home

Calculating the percentage of two numbers

teresa945
Occasional Visitor

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
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)

Hi @duco gm mansvelder

 

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

 

Cheers

Damien

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies