Home » Forums » Open Source Learning Center » Question and Answer

Excel formula to work out if improvements have been made

Submitted by JulieA on 3 April, 2012 - 16:00

Hi

Could you please let me know what formula I should use to work out if improvements have been made.

the example is that i have a figure from 2008 which is 4478 and the new figure is 575 so I know there is an improvement but I need to be able to work it out as a percentage

Thanks in advance
Julie

‹ Can you use a Vloopup with a Transpose function? reduction of excel file size ›
»
Nick's picture

julie in cell A1, put

Submitted by Nick on 4 April, 2012 - 09:44.

julie
in cell A1, put "OLD"
in cell B1, put "New"
in cell C1, put "% Change"

in cell A2, put 4478
in cell B2, put 575
in cell C2, put =TEXT((B2-A2)/A2,"0.0%")

you'll get: -87.2%
I hope this isn't your profit numbers !

»

Thank you Nick and no thank

Submitted by JulieA on 4 April, 2012 - 12:40.

Thank you Nick and no thank goodness it isn't ... this is a good figure for us as it shows a reduction :)

Thanks again

»
Nick's picture

aha... cost reduction

Submitted by Nick on 4 April, 2012 - 14:14.

aha... cost reduction then...
well done you !

»