Excel formula to work out if improvements have been made

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

Nick's picture

julie in cell A1, put

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

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

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