Question about Computers & Internet
Hi I have a spreadsheet that I need to update which is a pricelist but now need to add 20% to all the prices. What formula in excel do I need for this calculation.
Many thanks for your help
Lets say you have the column B with the prices. Got to column C right beside the first price cell (I'll take B2 as first cell for example) which is C2 and type
Copy this formula in the column C all the way down to the last price Cell. That will give you all the updated prices.
Before you delete the column B where all your old prices are you need to do one more thing. Select the entire C column (new prices) go to edit and click on copy. Before you click anywhere else go back to edit and click on paste special and select value. This will change the formula cell you have created a minute ago to a value cell. Now you can delete the old prices. Good luck :)
Posted on Feb 25, 2009
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Jun 22, 2017 | Excel Computers & Internet
on Mar 08, 2010 | Computers & Internet
May 06, 2016 | Casio Office Equipment & Supplies
May 11, 2017 | Savy Soda iSpreadsheet Free
Dec 10, 2008 | Microsoft Excel for PC
Dec 02, 2008 | Dymo LabelWriter 400 Thermal Printer
Nov 02, 2008 | Microsoft Windows XP Home Edition
Oct 08, 2008 | Microsoft Windows XP Home Edition
Sep 30, 2008 | Microsoft Excel for PC
4,215 people viewed this question
Usually answered in minutes!