If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I add 3% or 5 % to a column
I need to add a percentage to a column for my price list .
Can someone please help me |
#2
|
|||
|
|||
how do I add 3% or 5 % to a column
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
|
|||
|
|||
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 . Can someone please help me |
#4
|
|||
|
|||
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 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 |
Thread Tools | |
Display Modes | |
|
|