[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

[twototango]

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"

"S1L1Y1" wrote:

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

[Jim Thomlinson]

Put .95 in a cell. Copy that cell. Select the range you want to modify.
Choose Edit - Paste Special - Select Multiply.
--
HTH...

Jim Thomlinson


"S1L1Y1" wrote:

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

[Bob I]

put .95 in a cell Copy it, select the 300 items, Edit, paste special,
Multiply.

S1L1Y1 wrote:

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