Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 13th 05, 07:14 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2005
Posts: 11
Default 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   Report Post  
Old May 13th 05, 08:00 PM
Arvi Laanemets
 
Posts: n/a
Default

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   Report Post  
Old May 16th 05, 07:39 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2005
Posts: 11
Default

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:
Originally Posted by Arvi Laanemets
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
  #4   Report Post  
Old May 17th 05, 02:22 AM
Gord Dibben
 
Posts: n/a
Default

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-


  #5   Report Post  
Old May 18th 05, 07:29 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2005
Posts: 11
Default

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



  #6   Report Post  
Old May 18th 05, 08:28 PM
Peo Sjoblom
 
Posts: n/a
Default

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   Report Post  
Old May 18th 05, 08:30 PM
Barb R.
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to group similar column titles together???? vrk1 Excel Discussion (Misc queries) 2 April 30th 05 12:17 AM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM
Excel solver sensitivity report has empty shadow prices column? Lela Excel Discussion (Misc queries) 0 March 29th 05 02:55 PM
How do I combine a line and a percentage stacked column chart? Liza Charts and Charting in Excel 1 February 3rd 05 01:40 PM
DECREASE ALL NUMBERS IN A COLUMN BY A PERCENTAGE LoriK Excel Worksheet Functions 1 December 30th 04 05:45 PM


All times are GMT +1. The time now is 06:32 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017