how do I add 3% or 5 % to a column

D

Dave Peterson

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.
 
J

John

HI Sue
For 3%, type 1.03 in a cell copy it then select your column ( Range)
goto Edit>Paste 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
 
T

trip_to_tokyo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I make column C a percentage of column B 3
Net change and percentage of change 3
Getting the top 5 7
How do I calculate a percentage of a column? 2
add info to column 5
Excel Add 60 days to column 1 or column 2 based on whether column 2 has data 1
adding a percentage to a column of numbers 3
Macro to add numbers in a text string 5

Top