Formula to add a percentage to the same cell.

[Pkoike]

Greetings, I have a question.




So I have this excel file with a row with many prices, and I'm asked to add each cell in that row an additional 3% of its original value.


I was thinking in adding one row, so the previous row would be named "Original prices" (or something like that) and the new row: "New Prices".
How ever I was asked NOT to do that (I should not add any additional row or column).
The addition of the 3% must be applied in the same cell which contains the price itself, through a formula, not "manually".


The manual way would be something like:
=100+100*3%


But then again that's time consuming, and the addition must be applied to several cells in a row.


Help?

 

[Michael M]

Is this for an assignment ??

Look at copy / PasteSpecial

 

[Pkoike]

No, it's not for an assignment

Not sure what you mean by "pasteSpecial", I'm not a regular Excel user, someone I know just asked me how to do that and now it kept me thinking.

 

[Michael M]

Place 1.03 in a random empty cell, format as percent
Copy that cell>>highlight the range of cells to modify>>Right click and select PasteSpecial>>select Multiply from the options>>press OK
All cells will have had 3 % added...you can now delete the original cell that contains 1.03