I'm trying to calculate the percentage of two columns on various rows but
having problems.
I can do it easily enough for individual rows but it would be very time
consuming , e.g. on row 5 if i want to calculate the percentage of E5 by D5
and place the result in C5 I use the following formula: =(E5/D5), and for row
6 it would be: =(E6/D6) and so on, but what I want to do is for any row have
excel automiatically calculate the percentage of column E by colum D and
place the result in C.
Is there an easy way to do this?
Please excuse my atrocious explanation of what it is I'm after! No doubt
this could have been decribed far more concisely.
Thanks for your time.

You should be able to drag the formula down the page.

"winyard" wrote:

I'm trying to calculate the percentage of two columns on various rows but
having problems.
I can do it easily enough for individual rows but it would be very time
consuming , e.g. on row 5 if i want to calculate the percentage of E5 by D5
and place the result in C5 I use the following formula: =(E5/D5), and for row
6 it would be: =(E6/D6) and so on, but what I want to do is for any row have
excel automiatically calculate the percentage of column E by colum D and
place the result in C.
Is there an easy way to do this?
Please excuse my atrocious explanation of what it is I'm after! No doubt
this could have been decribed far more concisely.
Thanks for your time.

Drag it down from where? not sure what to drag down or how?!

"Chelby02" wrote:

You should be able to drag the formula down the page.

"winyard" wrote:

I'm trying to calculate the percentage of two columns on various rows but
having problems.
I can do it easily enough for individual rows but it would be very time
consuming , e.g. on row 5 if i want to calculate the percentage of E5 by D5
and place the result in C5 I use the following formula: =(E5/D5), and for row
6 it would be: =(E6/D6) and so on, but what I want to do is for any row have
excel automiatically calculate the percentage of column E by colum D and
place the result in C.
Is there an easy way to do this?
Please excuse my atrocious explanation of what it is I'm after! No doubt
this could have been decribed far more concisely.
Thanks for your time.

Copy the cell in question and "Paste" into the destination cells.

Otherwise select the cell and grab the lower right corner of the border
and drag down

winyard wrote:

Drag it down from where? not sure what to drag down or how?!

"Chelby02" wrote:


You should be able to drag the formula down the page.

"winyard" wrote:


I'm trying to calculate the percentage of two columns on various rows but
having problems.
I can do it easily enough for individual rows but it would be very time
consuming , e.g. on row 5 if i want to calculate the percentage of E5 by D5
and place the result in C5 I use the following formula: =(E5/D5), and for row
6 it would be: =(E6/D6) and so on, but what I want to do is for any row have
excel automiatically calculate the percentage of column E by colum D and
place the result in C.
Is there an easy way to do this?
Please excuse my atrocious explanation of what it is I'm after! No doubt
this could have been decribed far more concisely.
Thanks for your time.

Look up the term "fill handle" in Excel help.
--
David Biddulph

"winyard" wrote in message
...
Drag it down from where? not sure what to drag down or how?!

"Chelby02" wrote:

You should be able to drag the formula down the page.

"winyard" wrote:

I'm trying to calculate the percentage of two columns on various rows
but
having problems.
I can do it easily enough for individual rows but it would be very time
consuming , e.g. on row 5 if i want to calculate the percentage of E5
by D5
and place the result in C5 I use the following formula: =(E5/D5), and
for row
6 it would be: =(E6/D6) and so on, but what I want to do is for any row
have
excel automiatically calculate the percentage of column E by colum D
and
place the result in C.
Is there an easy way to do this?
Please excuse my atrocious explanation of what it is I'm after! No
doubt
this could have been decribed far more concisely.
Thanks for your time.