I have absolutly no experience with Excel. But I have a spreadsheet that i need help with.

What I need to do is add a percentage to a column and create a new column with the figured price.
For example

Columm D + 20% + column H

I know this is possible what formula do I need. Don't forget I am really green at this.

Marvin

 

Okay try this. My example will use columns A, B, C, and D. You can use whatever columns you need.

A1 - enter your price (assume 45)
B1 - enter the percentage (20% or .20)
C1 - enter this: =A1*B1
(C1 should now read 9)
D1 - enter this: =C1+A1
(D1 should now read 54.

I hope this helps

 

If you want the result of your calcuation (Col 1 + 20%) to go in Col 2, then you should put '=Col1 x 1.2' in Col2.

 

If cel a1 is the price and you want to show the result (price a1 +20 %) in cel b1 then insert this formula in cel b1.

=a1+(0.2xa1)

To insert formula's in all cells of column B.
Highlight cel b1, copy.
Select all cells that you want in column B.
Choose paste special......
Choose radio button formula's
OK


Hope this is what you mean.
This is for a fixed percentage of 20%

 

Got it figured out. Thanks for all the help. Thats what I like about this board, a wealth of information.

Marvin