Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need to add a certain percentage to a column of prices
I have excel 200. I am wanting to add a certain percentage like 20%, etc... to a column of prices. for example if the price on the column was 10.00 it would increase it to 12.00(20% increase).
Can this be done. Please help... Thanks in advance, Glowinafuse :) |
#2
|
|||
|
|||
Hi
a) With new price in new column (p.e. with price in cell A2) =A2*1.2 b) When you want to overwrite old prices with new ones: - Enter 1.2 into any free (empty) cell. Copy the cell; - Select the renge with prices; - from Edit menu, or from right-click drop-down, select Paste Special, and select Multiply option. OK. It's done! Arvi Laanemets "Glowinafuse" wrote in message ... I have excel 200. I am wanting to add a certain percentage like 20%, etc... to a column of prices. for example if the price on the column was 10.00 it would increase it to 12.00(20% increase). Can this be done. Please help... Thanks in advance, Glowinafuse :) -- Glowinafuse |
#3
|
|||
|
|||
Okay, I am new to this, and I am trying to understand. But where do you put that formula? how... I need to learn this real quick for something at work.
Quote:
|
#4
|
|||
|
|||
Assuming your column of prices is Column A.
In B1 enter =A1*1.2 Double-click on the fill handle(small black lump on bottom right corner) of B1 to fill down. Easiest is to just type the number 1.2 in an empty cell and do the copypaste specialmultipleOKEsc as Arv1 suggests. But this will overwrite the originals. Gord Dibben Excel MVP On Mon, 16 May 2005 19:39:07 +0100, Glowinafuse wrote: Okay, I am new to this, and I am trying to understand. But where do you put that formula? how... I need to learn this real quick for something at work. Arvi Laanemets Wrote: Hi a) With new price in new column (p.e. with price in cell A2) =A2*1.2 b) When you want to overwrite old prices with new ones: - Enter 1.2 into any free (empty) cell. Copy the cell; - Select the renge with prices; - from Edit menu, or from right-click drop-down, select Paste Special, and select Multiply option. OK. It's done! Arvi Laanemets "Glowinafuse" wrote in message ...- I have excel 200. I am wanting to add a certain percentage like 20%, etc... to a column of prices. for example if the price on the column was 10.00 it would increase it to 12.00(20% increase). Can this be done. Please help... Thanks in advance, Glowinafuse :) -- Glowinafuse- |
#6
|
|||
|
|||
Or it could be put in another cell as percentage and use
=A1*(1+B1) where B1 would hold the percentage Regards, Peo Sjoblom "Barb R." wrote: For the items that require a higher markup, you'll need to change this equation (in B1) = A1*1.2 to =A1*1.25 In the appropriate fields. "Glowinafuse" wrote: Okay, Now how do I change the percentage? Like lets say I want to change it from the 20% to 25%. How do I input that? Cause i will have other items which will require hiher percenatge markup? Please let me know. You guys have been great!!! Glowinafuse Gord Dibben Wrote: Assuming your column of prices is Column A. In B1 enter =A1*1.2 Double-click on the fill handle(small black lump on bottom right corner) of B1 to fill down. Easiest is to just type the number 1.2 in an empty cell and do the copypaste specialmultipleOKEsc as Arv1 suggests. But this will overwrite the originals. Gord Dibben Excel MVP On Mon, 16 May 2005 19:39:07 +0100, Glowinafuse wrote: - Okay, I am new to this, and I am trying to understand. But where do you put that formula? how... I need to learn this real quick for something at work. Arvi Laanemets Wrote:- Hi a) With new price in new column (p.e. with price in cell A2) =A2*1.2 b) When you want to overwrite old prices with new ones: - Enter 1.2 into any free (empty) cell. Copy the cell; - Select the renge with prices; - from Edit menu, or from right-click drop-down, select Paste Special, and select Multiply option. OK. It's done! Arvi Laanemets "Glowinafuse" wrote in message ...- I have excel 200. I am wanting to add a certain percentage like 20%, etc... to a column of prices. for example if the price on the column was 10.00 it would increase it to 12.00(20% increase). Can this be done. Please help... Thanks in advance, Glowinafuse :) -- Glowinafuse--- -- Glowinafuse |
#7
|
|||
|
|||
For the items that require a higher markup, you'll need to change this equation
(in B1) = A1*1.2 to =A1*1.25 In the appropriate fields. "Glowinafuse" wrote: Okay, Now how do I change the percentage? Like lets say I want to change it from the 20% to 25%. How do I input that? Cause i will have other items which will require hiher percenatge markup? Please let me know. You guys have been great!!! Glowinafuse Gord Dibben Wrote: Assuming your column of prices is Column A. In B1 enter =A1*1.2 Double-click on the fill handle(small black lump on bottom right corner) of B1 to fill down. Easiest is to just type the number 1.2 in an empty cell and do the copypaste specialmultipleOKEsc as Arv1 suggests. But this will overwrite the originals. Gord Dibben Excel MVP On Mon, 16 May 2005 19:39:07 +0100, Glowinafuse wrote: - Okay, I am new to this, and I am trying to understand. But where do you put that formula? how... I need to learn this real quick for something at work. Arvi Laanemets Wrote:- Hi a) With new price in new column (p.e. with price in cell A2) =A2*1.2 b) When you want to overwrite old prices with new ones: - Enter 1.2 into any free (empty) cell. Copy the cell; - Select the renge with prices; - from Edit menu, or from right-click drop-down, select Paste Special, and select Multiply option. OK. It's done! Arvi Laanemets "Glowinafuse" wrote in message ...- I have excel 200. I am wanting to add a certain percentage like 20%, etc... to a column of prices. for example if the price on the column was 10.00 it would increase it to 12.00(20% increase). Can this be done. Please help... Thanks in advance, Glowinafuse :) -- Glowinafuse--- -- Glowinafuse |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Excel solver sensitivity report has empty shadow prices column? | Excel Discussion (Misc queries) | |||
How do I combine a line and a percentage stacked column chart? | Charts and Charting in Excel | |||
DECREASE ALL NUMBERS IN A COLUMN BY A PERCENTAGE | Excel Worksheet Functions |