how do i set up autosum as a %
 

Trying to set up figures from one year to next and would like to show
difference as a %

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 %