Hi, i am trying to increase a range of cells by say 10%, then add this percentage on to that range of cells to show new price.
I know how to use a single cell and set by 10% and use paste special and mulitiply, but how do I add this percentage on to original figure.
for example
10.00 x 10% = 1.00 ( i need to show the figure in the box as 11.00
11.00 x 10% = 1.10 (i need to show the figure in the box as 12.10
12.00 and so on
13.00 and so on
is there a formula to do this
any help much appreciated.
Bookmarks