var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Percentage Difference
I know that formula to work out the Percentage Difference. But I the results are not formatted correctly.
| New Value – Old Value |
_____________________ x 100%
| Old Value |
450 – 781
________ x 100
The result I get is -42
I how do I format the cell so it shows as an Absolute number and with a percentage sign?
Thank in advance
to get the absolute number use the following formula
Then right click in the cell and set the cell format to percentage.
You will notice from the formula that I have removed the *100 since the formatting as a percentage will do that bit of the sum for you.
Hope this helps
cheers mate you a STAR!