Trying to set up figures from one year to next and would like to show difference as a %
R Robert s Feb 7, 2007 #1 Trying to set up figures from one year to next and would like to show difference as a %
B Bill Kuunders Feb 7, 2007 #2 =(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
=(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
