Excel question

[h2009]

Hi there,
I've got a big list of numbers that i need to adjust the figures of showing the result in same cell, as the original. If you look below, for example needing to add 17% to each cell, where each cell has a different number. Basically i need to preserve the original figure, yet updating the cell with add/subtracting/multi/percent.

Is there anyway to do this, fast, instead of retyping each cell?

i.e.
Original
A1 = 100
A2 = 200
A3 = 150

Changed
A1 = 100 +17%
A2 = 200 +17%
A3 = 150 +17%

 

[h2009]

thanks for your reply.
But i was hoping to have a reference cell i.e. if i put 22% in C1, then all of A cells update, accordingly.

The only way i can think about doing this is on a new sheet :/ but that like a 'cut and weld' job.