Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I need to add a percentage to a column for my price list .
Can someone please help me |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Put 1.03 (or 1.05) in an empty cell.
Edit|copy that cell Select the range to adjust. 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 . Can someone please help me -- Dave Peterson |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 . Can someone please help me |
#4
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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 If my comments have helped please hit Yes. Thanks. "Sue" wrote: I need to add a percentage to a column for my price list . Can someone please help me |
#5
![]() |
|||
|
|||
![]()
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
divide column(x) by column(y) to give column(x/y) in excel? | New Users to Excel | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Return text in Column A if Column B and Column K match | Excel Worksheet Functions | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
formula : =(column A)+(column B)-(column C). Why won't it work? | Excel Discussion (Misc queries) |