dividing one column by another

[larry_Meiners]

Version: 2008

I would appreciate someone guiding me through a division situation.
I have a column of numbers (say c) and with to divide this column by a constant number (say .92) which would be in column d.

I am working up a price sheet with different pricing (column c) and we are having a price increase of .92 (column d)

thanks

larry

 

[Bob Greenblatt]

Version: 2008

I would appreciate someone guiding me through a division situation.
I have a column of numbers (say c) and with to divide this column by a
constant number (say .92) which would be in column d.

I am working up a price sheet with different pricing (column c) and we are
having a price increase of .92 (column d)

thanks

larry

You can easily do this by selecting the cell containing the .92 and then
copying it. Then select al the numbers in column C where you wish to apply
this and then go to Edit-paste Special, and select values and divide.

 

[CyberTaz]

Hi Larry -

I'm afraid it isn't really clear what you want to do. I'm interpreting this
to mean that you have a list of prices in Column C, but I can't tell if you
want to have the new prices computed while retaining the originals or
whether you actually want to have the original prices *changed*.

Assuming you want to have both the old as well as the new, that the original
prices are in C1:C50, and you want the increased prices adjacent to them in
cells D150 you can do this in at least 2 ways;

1- in cell D1 enter the formula: =C1/.92 then use the Fill handle to
copy the formula down to cell D50, or

2- Enter the value of .92 in a cell - let's say F1. Then in cell D1 enter
the formula =C1/$F$1 (make sure to include the $ as shown so the
reference to F1 doesn't change as you copy the formula) then copy down to
D50 as above.
[An advantage of this method is that you can change the value in F1 any time
you want to divide the original prices by a different factor without having
to update or replace each of the formulas.]

If you actually want to *change* the prices in column C do this:

Enter the value of .92 in any cell, then copy it,
Select cells C1:C50 then go to Edit> Paste Special & select the Divide
option in the Operation section of the dialog window, then click OK.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[larry_Meiners]

Hi Larry -

I'm afraid it isn't really clear what you want to do. I'm interpreting this
to mean that you have a list of prices in Column C, but I can't tell if you
want to have the new prices computed while retaining the originals or
whether you actually want to have the original prices *changed*.

Assuming you want to have both the old as well as the new, that the original
prices are in C1:C50, and you want the increased prices adjacent to them in
cells D150 you can do this in at least 2 ways;

1- in cell D1 enter the formula: =C1/.92 then use the Fill handle to
copy the formula down to cell D50, or

2- Enter the value of .92 in a cell - let's say F1. Then in cell D1 enter
the formula =C1/$F$1 (make sure to include the $ as shown so the
reference to F1 doesn't change as you copy the formula) then copy down to
D50 as above.
[An advantage of this method is that you can change the value in F1 any time
you want to divide the original prices by a different factor without having
to update or replace each of the formulas.]

If you actually want to *change* the prices in column C do this:

Enter the value of .92 in any cell, then copy it,
Select cells C1:C50 then go to Edit> Paste Special & select the Divide
option in the Operation section of the dialog window, then click OK.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Version: 2008

I would appreciate someone guiding me through a division situation.
I have a column of numbers (say c) and with to divide this column by a
constant number (say .92) which would be in column d.

I am working up a price sheet with different pricing (column c) and we are
having a price increase of .92 (column d)

thanks

larry

Bob:

A good teacher, I am not a very good student.

Let me give you a actual situation:

In column D - $20.04. Now what do I do - you are correct - I wish to have their last price x .92 which will =their new price. They can then quickly see the old and the new

thanks again

larry

 

[CyberTaz]

Well, now you've confused me You first indicated you wanted to *divide*
prices in Column C by .92, now you're saying you want to *multiply* prices
in Column D by .92 - Are you increasing prices or discounting them? How
about spelling out exactly what you have, how you have it laid out & what it
is that you want as a result. I'll be glad to give you a suggestion

BTW - I don't want to get into a pointless argument over Top posting as
opposed to bottom posting, but regardless of personal preference it is
generally more acceptable to follow the pattern established in a thread.
Otherwise it makes it very difficult for anyone to have to bounce around
from one message to another trying to follow the conversation

Regards |:>)
Bob Jones
[MVP] Office:Mac

Hi Larry -

I'm afraid it isn't really clear what you want to do. I'm interpreting this
to mean that you have a list of prices in Column C, but I can't tell if you
want to have the new prices computed while retaining the originals or
whether you actually want to have the original prices *changed*.

Assuming you want to have both the old as well as the new, that the original
prices are in C1:C50, and you want the increased prices adjacent to them in
cells D150 you can do this in at least 2 ways;

1- in cell D1 enter the formula: =C1/.92 then use the Fill handle to
copy the formula down to cell D50, or

2- Enter the value of .92 in a cell - let's say F1. Then in cell D1 enter
the formula =C1/$F$1 (make sure to include the $ as shown so the
reference to F1 doesn't change as you copy the formula) then copy down to
D50 as above.
[An advantage of this method is that you can change the value in F1 any time
you want to divide the original prices by a different factor without having
to update or replace each of the formulas.]

If you actually want to *change* the prices in column C do this:

Enter the value of .92 in any cell, then copy it,
Select cells C1:C50 then go to Edit> Paste Special & select the Divide
option in the Operation section of the dialog window, then click OK.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Version: 2008

I would appreciate someone guiding me through a division situation.
I have a column of numbers (say c) and with to divide this column by a
constant number (say .92) which would be in column d.

I am working up a price sheet with different pricing (column c) and we are
having a price increase of .92 (column d)

thanks

larry

Bob:

A good teacher, I am not a very good student.

Let me give you a actual situation:

In column D - $20.04. Now what do I do - you are correct - I wish to have
their last price x .92 which will =their new price. They can then quickly see
the old and the new

thanks again

larry