Posted to microsoft.public.excel.worksheet.functions
|
|
how do i set up autosum as a %
=(B2/A2-1)*100
B2 has this year
A2 was last year
You can format the cell as a %, the formula would then be =B2/A2-1
--
Greetings from New Zealand
"Robert s" <Robert wrote in message
...
Trying to set up figures from one year to next and would like to show
difference as a %
|