1) Old Price New Price
2) $10.00 $10.70
3) $200.00 $214.00
4) $3,000.00 $3,210.00
In cell B2 enter the formula: =(A2*0.07)+A2
Drag down as many cells as needed.
Now select your New Price cells and do a Copy
Now select your Old Price cells and do a Paste / Special / Values
Delete column B and your done.