View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default 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 %