Forum Discussion

Copper Contributor

Nov 19, 2018

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?

Formulas and Functions

3 Replies

duco gm mansvelder
Copper Contributor
Nov 19, 2018
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)
- Damien_Rosario
  Silver Contributor
  Nov 20, 2018
  Hi duco gm mansvelder
  
  I think you meant to say B2 = B1/(A1+B1).
  
  Cheers
  Damien
  - duco gm mansvelder
    Copper Contributor
    Nov 22, 2018
    Correct!