How do I copy a function formula?
 

Hi!
I calculated the cost of a product by multiplying the product price by the
quantity. (That's my excercise). And I have to copy that formula in cell F7
into the cells F8:F9, F15:F19, F25:F26.
The first formula should look like: =D7*E7. And then copied into the other
cells.
How I should do it?
Please, RSVP as soon as possible.

How do I copy a function formula?
 

Hi,

Type =D7*E7 in cell F7.

Then copy that formula down to the range you need. The references would
change automatically when you copy the formulas.

Regards

Govind.

Matilde wrote:

Hi!
I calculated the cost of a product by multiplying the product price by the
quantity. (That's my excercise). And I have to copy that formula in cell F7
into the cells F8:F9, F15:F19, F25:F26.
The first formula should look like: =D7*E7. And then copied into the other
cells.
How I should do it?
Please, RSVP as soon as possible.

How do I copy a function formula?
 

OK, but how to copy:
- Drag and drop
- Copy / Paste
-Or other ways...

Thanks for helping me... I learned Excel in Argentina almost 10 years ago
but my mistake is not have practiced for a long time. And now it's in
English, so everything is more difficult and I'm not used to think too much
lately.
Email me.
Bye.

"Govind" wrote:

Hi,

Type =D7*E7 in cell F7.

Then copy that formula down to the range you need. The references would
change automatically when you copy the formulas.

Regards

Govind.

Matilde wrote:

Hi!
I calculated the cost of a product by multiplying the product price by the
quantity. (That's my excercise). And I have to copy that formula in cell F7
into the cells F8:F9, F15:F19, F25:F26.
The first formula should look like: =D7*E7. And then copied into the other
cells.
How I should do it?
Please, RSVP as soon as possible.

How do I copy a function formula?
 

Hi,

Use Copy/Paste.

Regards

Govind.

Matilde wrote:

OK, but how to copy:
- Drag and drop
- Copy / Paste
-Or other ways...

Thanks for helping me... I learned Excel in Argentina almost 10 years ago
but my mistake is not have practiced for a long time. And now it's in
English, so everything is more difficult and I'm not used to think too much
lately.
Email me.
Bye.

"Govind" wrote:


Hi,

Type =D7*E7 in cell F7.

Then copy that formula down to the range you need. The references would
change automatically when you copy the formulas.

Regards

Govind.

Matilde wrote:


Hi!
I calculated the cost of a product by multiplying the product price by the
quantity. (That's my excercise). And I have to copy that formula in cell F7
into the cells F8:F9, F15:F19, F25:F26.
The first formula should look like: =D7*E7. And then copied into the other
cells.
How I should do it?
Please, RSVP as soon as possible.