Deduct a percent from list

  • Thread starter Thread starter S1L1Y1
  • Start date Start date
S

S1L1Y1

I would like to ask. I have a pricelist of about 300 items, and I want to
deduct 5% from the cost all items. Is there a way to do it at once or do I
have to go to each one separately?
Sol
 
Put .95 in a cell. Copy that cell. Select the range you want to modify.
Choose Edit -> Paste Special -> Select Multiply.
 
insert column next to your prices. assuming data starts in "A1" in "B1"
write: =A1*.95 This will give you your price less 5%. Copy down the
column. If you want to replace values in your original price column with
new price, click on column "copy" then highlight original column "paste
special" and "values"
 
put .95 in a cell Copy it, select the 300 items, Edit, paste special,
Multiply.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deducting minutes off running total 2
Automatic Deduction? 1
Notice in Excel of a reached set point setting. 5
how do i make a formula with varied discount percentages 3
Deduct until last positive number remaining 1
Simplifying a formula that prevents negative numbers 3
how do i add a formula to a cell that will add or subrtact from d. 2
deduct 30 minutes from a shift calculation in hours 1

Back
Top