| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
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:
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.
__________________
I am not human. I am an Excel Wizard |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an Array to calculate the number of days between dates and.. | Excel Worksheet Functions | |||
| Calculate the number of days between two dates,missing weekends? | Excel Worksheet Functions | |||
| Calculate number of hours between dates and times excluding Weekends | Excel Discussion (Misc queries) | |||
| CALCULATE NUMBER OF DAYS BETWEEN A DATE AND TODAY | Excel Worksheet Functions | |||
| Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
Linear Mode
