Excel Percentage

[Jenni]

I am trying to multipy all of the numbers that I have in my excel worksheet by 25%. The only problem that I am having is that I can't figure out how to make excel add the 25% figure back to my original number.

Okay lets give an example
In cell a3 I have the number 67.17
I then put in cell a4 =*25%
My problem is that excel comes up with the correct percentage for 67.17 which is 16.7925, but I cant get it to take that 67.17 and add the 16.7925 to it. Please help

[Asala42]

G'day,

Did you mean that you actually want to multiply your current values by 1.25? (Meaning increase your current values by 25%)

Adam

[gbarclay2001]

put in a4 =a3*1.25

[ This Message was edited by: gbarclay2001 on 2002-05-14 07:50 ]

[sann0638]

Jenni,
multiply by 125%

Rgds
Mike

[Chris Davison]

On 2002-05-14 07:47, Jenni wrote:
I am trying to multipy all of the numbers that I have in my excel worksheet by 25%. The only problem that I am having is that I can't figure out how to make excel add the 25% figure back to my original number.

Okay lets give an example
In cell a3 I have the number 67.17
I then put in cell a4 =*25%
My problem is that excel comes up with the correct percentage for 67.17 which is 16.7925, but I cant get it to take that 67.17 and add the 16.7925 to it. Please help

if you really want to multiply *every* number by 125%, try this :

put 1.25 in a spare cell, right click it, select "copy"
then select edit, goto, special
select : constants and just numbers, click on ok

this should highlight all instances of numbers in your worksheet

right click one of them and select paste special, then multiply

it should multiply every number by 1.25, which is the same as adding 25% to the original number

Hope this helps,
Chris


marker paste special multiply

[WayneTN]

Jenni,

A similar, but alternative way to multiply all cells containing your data by the same number is this. Put the multiplying factor in a spare cell, say F1. If your first amount is in A3, then in cell A4 enter =A3*$F$1. Then just click once on the cell and select the handle (lower right corner) and drag the formula down the column or across the row (whichever applies) next to your original data. This way you will generate formulae for all calculation cells while retaining the location of the "factor". The good thing about doing it this way is that, if you want to change the factor, all of the cells recalculate accordingly.

Good luck!
Wayne

[Jenni]

Thank you sooooo much to everyone who helped me with this problem.

It is all done now.

Thanks,

Jen