Question about Computers & Internet

1 Answer

Add 20% uplift price to a pricelist in an excel spreedsheet

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

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 67 Answers

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
=1.2*B2

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

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert 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 repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

How to add comma in spreadsheet? thanks


To add commas to your spreadsheet you need the format the numbers. If you want your whole spreadsheet to use commas, click on the area to the left of column A and above number 1. This should highlight the whole spreadsheet. Click on the "," icon in the "number" area, and your spreadsheet will be formatted to put commas in.

Good luck,

Paul

May 06, 2016 | Casio Office Equipment & Supplies

Tip

How to convert excel to PDF


According to a recent report,Adobe estimates that there are about 300
million PDF in circulation,the amount and use of PDF format is still growing exponentially.People nowadays cannot live without PDF files.
Sometimes,you need to convert excel to pdf files,but how to convert excel spreadsheets to pdf with retains all the features of the original excel file?

you will need pdf converter to convert excel to pdf.

1.Run the pdf converter program.

2.Add PDF files,specify output folder.

3.Start conversion.

Note: you cn add PDF properties to the output PDF file, like author, passwords, allowed actions, etc.

on Mar 08, 2010 | Computers & Internet

1 Answer

Please tell me current price of MMX310G USB MODEM in INDIA ?


HEY HI BUDDY......
NOT ONLY FOR MODEM,YOU CAN CHECK THE PRICE OF ALL ELECTRONIC ITEMS IN THIS SITE...... http://delhi.quikr.com/micromax-usb-3g-modem-mmx310g-pricelist-all/micromax-usb-3g-modem-mmx310g-pricelist/x27

THAMK YPU...GOOD DAY

Sep 22, 2010 | Cell Phones

1 Answer

Need to use the VLOOKUP formula for more then one column


You probably need to organise your pricelist sheet so that you only have 2 columns, product and price. If this doesn't fix you, please provide the syntax of your vlookup code.

Dec 10, 2008 | Microsoft Excel for PC

1 Answer

Import information from a spreedsheet


use the "print from a database" function that the software for the DYMO has. It will allow you to import a database (in this cae your excel spreadsheet) and "map" it to the fields on an address label, like first name, address etc.

Dec 02, 2008 | Dymo LabelWriter 400 Thermal Printer

1 Answer

Percentage formula


=(Click cell that you want to work out 30% of)*30/100

Nov 30, 2008 | Microsoft Excel for PC

1 Answer

IF formula for letter grading in excell spreedsheet


Hi,

If you can email experts@fixya.com to forward me your email address (should this be agreeable), I can send you a copy of an excel sheet that automatically computes the grade and have the final grade in 1.0, 1.25, 1.50, 1.75 etc. You can then substitute the A, B, C.

Hope this be of initial help/idea. Pls post back how things turned up or should you need additional information.

Good luck and kind regards. Thank you for using FixYa.

Nov 02, 2008 | Microsoft Windows XP Home Edition

1 Answer

Spreadsheet formulaes


1. enter = symbol
2. enter ( symbol
2. enter cell location where your cost value is
3. enter * symbol
4. enter 0.7
5. enter ) symbol
6. enter 0.175


eg. =(A3*0.7)*0.175 where A3 is the cell location where your cost amount is

Oct 08, 2008 | Microsoft Windows XP Home Edition

1 Answer

Excel Spreadsheet


It could have a virus or simply too much data in it or too much data linked to it. Try doing a copy of the whole spreadsheet, and then paste the data into a new spreadsheet. If it doesn't contain too many different formulas, try pasting only the values, and then replace the formulas manually. You might also try just deleting the links, if there are any. If this doesn't solve it, reply to this thread and let us know.

Hope this will FixYa!!!

Sep 30, 2008 | Microsoft Excel for PC

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

4,186 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

102366 Answers

David Payne
David Payne

Level 3 Expert

14161 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...