Deducting 20% off a column.

**wiggo** · 09-02-2009, 08:03 AM

Hi all,

I hope someone can help me.

I am having difficulty deducting 20% automatically off an entire column. At the moment I am working it out manually with a calculator and over-writing the amount in the specified column.

Their are a few thousand amounts I need to change and I thought their must be a way of doing it in one go to speed things up a bit.

Just to point out that the numbers in the column do not amount to anything, they are simply prices (e.g. £45.90) next to a job description.

I hope you understand what I mean.

Many thanks,

Wiggo

**Ron Coderre** · 09-02-2009, 08:09 AM

Try this....

• Enter 0.8 in an empty cell and select that cell.

(80% is the value you want to retain in the impacted cells.)

• Excel menu: Edit.Copy
• Select the cells to be impacted
• Excel menu: Edit.Paste_Special.Multiply

That will multiply each cell by 0.8 and replace the previous value with the result

• Press ESC to end Cut/Copy Mode.

Is that something you can work with?

**wiggo** · 09-02-2009, 08:46 AM

Thanks for the quick response, it certainly did help.

Do you by any chance know how I would add the 20% back on to a reduced total?

When I try and add 20% to a figure that has been reduced, it obviously doesn't make the same total as before.

Many thanks for your time.

Wiggo

**Macdave_19** · 09-02-2009, 08:51 AM

Do the same but with 1.25

**Ron Coderre** · 09-02-2009, 08:53 AM

Originally Posted by wiggo

Thanks for the quick response, it certainly did help.

Do you by any chance know how I would add the 20% back on to a reduced total?

When I try and add 20% to a figure that has been reduced, it obviously doesn't make the same total as before.

Many thanks for your time.

Wiggo

Yes....

• In an empty cell, enter: =100/80
• Select that cell
• Excel menu: Edit.Copy
• Select the cells to be impacted
• Excel menu: Edit.Paste_Special.Multiply

Does that help?

**wiggo** · 09-02-2009, 09:01 AM

Absolutely first class.

You help is really appreciated.

I'll be coming back if I need more help.

Wiggo

**Forkie** · 09-23-2009, 08:33 AM

Originally Posted by wiggo

Hi all,

I hope someone can help me.

I am having difficulty deducting 20% automatically off an entire column. At the moment I am working it out manually with a calculator and over-writing the amount in the specified column.

Their are a few thousand amounts I need to change and I thought their must be a way of doing it in one go to speed things up a bit.

Just to point out that the numbers in the column do not amount to anything, they are simply prices (e.g. £45.90) next to a job description.

I hope you understand what I mean.

Many thanks,

Wiggo

I have a similar question. However, I want to put the result of the calculation into a different cell i.e., I want to add 30% to a number in a cell, but have the answer appear in another cell. How can I do this?

**Special-K** · 09-23-2009, 08:35 AM

Assuming the original number is in A1

In the "different cell" enter =A1*130%

**shg** · 09-23-2009, 08:41 AM

Welcome to the forum, Forkie.

Please take a few minutes to read the forum rules before posting again -- particularly the one about not posting questions in other peoples' threads.

Thanks.

**Forkie** · 09-23-2009, 08:51 AM

That's great! Thanks very much!

**Forkie** · 09-23-2009, 10:34 AM

Originally Posted by shg

Welcome to the forum, Forkie.

Please take a few minutes to read the forum rules before posting again -- particularly the one about not posting questions in other peoples' threads.

Thanks.

My apologies, I only added it here as it was just an extension of the original question. But I will start a new thread in future.

Thanks.