Hi,

I'm trying to create a formula which multiplies a cell adjacent to cell by
60 for which to formula is being applied.

For example, I have two columns C & D
Column C contains Time in Hours, I want to create a formula that applies
to each cell in Column D, which multiplies C by 60, but I don't
want to have to use the row number in my formula. How is this done?

Thanks

I don't see how you're going to get away with not using a row number in some
fashion.

Assuming the data starts in cell C1, enter in D1
=C1*60

Then copy the formula down column D (hover cursor over the black square in
the bottom right of the cell and drag down column D). Excel will adjust the
cell reference when the formula is copied.

See help for relative reference versus absolute reference.

"Opa" wrote:

Hi,

I'm trying to create a formula which multiplies a cell adjacent to cell by
60 for which to formula is being applied.

For example, I have two columns C & D
Column C contains Time in Hours, I want to create a formula that applies
to each cell in Column D, which multiplies C by 60, but I don't
want to have to use the row number in my formula. How is this done?

Thanks

Thanks JMB.
The drag feature is what I was looking for since I did not want to manually
create
the formulas for each cell.


"JMB" wrote:

I don't see how you're going to get away with not using a row number in some
fashion.

Assuming the data starts in cell C1, enter in D1
=C1*60

Then copy the formula down column D (hover cursor over the black square in
the bottom right of the cell and drag down column D). Excel will adjust the
cell reference when the formula is copied.

See help for relative reference versus absolute reference.

"Opa" wrote:

Hi,

I'm trying to create a formula which multiplies a cell adjacent to cell by
60 for which to formula is being applied.

For example, I have two columns C & D
Column C contains Time in Hours, I want to create a formula that applies
to each cell in Column D, which multiplies C by 60, but I don't
want to have to use the row number in my formula. How is this done?

Thanks

How are you entering the formula?

Manually?

You can select the range D1:D999 (or whatever)
then with D1 the active cell, you can type that formula for that one cell:

=c1*60

But instead of hitting enter to fill that one cell, hit ctrl-enter to fill the
complete selection (D1:D999). Excel will adjust the formula just like it would
if you dragged it down.



Opa wrote:

Thanks JMB.
The drag feature is what I was looking for since I did not want to manually
create
the formulas for each cell.

"JMB" wrote:

I don't see how you're going to get away with not using a row number in some
fashion.

Assuming the data starts in cell C1, enter in D1
=C1*60

Then copy the formula down column D (hover cursor over the black square in
the bottom right of the cell and drag down column D). Excel will adjust the
cell reference when the formula is copied.

See help for relative reference versus absolute reference.

"Opa" wrote:

Hi,

I'm trying to create a formula which multiplies a cell adjacent to cell by
60 for which to formula is being applied.

For example, I have two columns C & D
Column C contains Time in Hours, I want to create a formula that applies
to each cell in Column D, which multiplies C by 60, but I don't
want to have to use the row number in my formula. How is this done?

Thanks

--

Dave Peterson

Hi,
punch key"F4" to change the relative reference to absolute reference.

JMB wrote:
I don't see how you're going to get away with not using a row number in some
fashion.

Assuming the data starts in cell C1, enter in D1
=C1*60

Then copy the formula down column D (hover cursor over the black square in
the bottom right of the cell and drag down column D). Excel will adjust the
cell reference when the formula is copied.

See help for relative reference versus absolute reference.

"Opa" wrote:

Hi,

I'm trying to create a formula which multiplies a cell adjacent to cell by
60 for which to formula is being applied.

For example, I have two columns C & D
Column C contains Time in Hours, I want to create a formula that applies
to each cell in Column D, which multiplies C by 60, but I don't
want to have to use the row number in my formula. How is this done?

Thanks