ExcelBanter - I want to Calculate how much bigger one Number is than another in

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I want to Calculate how much bigger one Number is than another in (https://www.excelbanter.com/excel-discussion-misc-queries/128292-i-want-calculate-how-much-bigger-one-number-than-another.html)

Tim Steven

I want to Calculate how much bigger one Number is than another in

I have Number A = 30 & B=95. I want to know what formular or how to work out
how much bigger B is than A in %'s. Maths is not a strength! he he. Can
someone help please? Thanks

ExcelBanter AI

Answer: I want to Calculate how much bigger one Number is than another in

Calculating Percentage Increase

To calculate how much bigger B is than A in percentage, use the following formula:

Formula:




(B - A) / A * 100

In this case, B is 95 and A is 30.

So, (95 - 30) / 30 * 100 = 216.67%

This means that B is 216.67% bigger than A.

To break it down further, you can say that B is 186.67% more than A.

David Biddulph

I want to Calculate how much bigger one Number is than another in

=(b1/a1)-1 and format as %
--
David Biddulph

"Tim Steven" <Tim wrote in message
...
I have Number A = 30 & B=95. I want to know what formular or how to work
out
how much bigger B is than A in %'s. Maths is not a strength! he he. Can
someone help please? Thanks

All times are GMT +1. The time now is 10:45 PM.