Remember Me?

#1
Posted to microsoft.public.excel.newusers
 external usenet poster Posts: 285
how do I add 3% or 5 % to a column

I need to add a percentage to a column for my price list .
#2
Posted to microsoft.public.excel.newusers
 external usenet poster Posts: 35,218
how do I add 3% or 5 % to a column

Put 1.03 (or 1.05) in an empty cell.
Edit|copy that cell
edit|paste special|choose multiply and values

Clean up that cell with 1.03/1.05 in it.

Sue wrote:

I need to add a percentage to a column for my price list .

--

Dave Peterson
#3
Posted to microsoft.public.excel.newusers
 external usenet poster Posts: 694
how do I add 3% or 5 % to a column

HI Sue
For 3%, type 1.03 in a cell copy it then select your column ( Range)
goto EditPaste special and select Multiply. you can delete the 1.03 and change
it to 1.05
and do the same thing again for your other range.
HTH
John
"Sue" wrote in message
...
I need to add a percentage to a column for my price list .

#4
Posted to microsoft.public.excel.newusers
 external usenet poster Posts: 833
how do I add 3% or 5 % to a column

In cell A 1 I have 100

In cell B 1 I have 0.03

In cell C 1 I have:-

=(A1*B1)+A1

- giving a result of 103 in cell C 1

Thanks.

"Sue" wrote:

I need to add a percentage to a column for my price list .

#5
 Member Posts: 47
drag formula to a column

Hello!

if you want to add 3% or 5% to a column, first, we'll name the base column as Column A, then if we want to add 3% to 5% on to column A, we just need to put 1.03 or 1.05 to a random cell, Z1. Now, we can place a formula on another column, B, and use the formula:

=A*Z1

on Column B, and just drag it until the last entry of the column A. now we get a 3% increase for all the entries in Column A which are in Column B.

For more tips on excel and Financial Models, you can check this out. Hope this Helps!

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post TVGuy29 Excel Discussion (Misc queries) 1 January 24th 08 09:50 PM jeannie v Excel Worksheet Functions 4 December 13th 07 07:36 PM [email protected] Excel Discussion (Misc queries) 1 December 27th 06 05:47 PM James New Users to Excel 1 November 9th 06 11:59 PM Kristin Drover Excel Discussion (Misc queries) 3 October 18th 06 08:48 PM

All times are GMT +1. The time now is 12:22 PM.