Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating percentage-using rows
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
getting #DIV/0! when calculating percentage | Excel Worksheet Functions | |||
calculating a percentage | Excel Discussion (Misc queries) | |||
Calculating a percentage with the end percentage in mind | Excel Discussion (Misc queries) | |||
Calculating Percentage | Excel Worksheet Functions | |||
Calculating percentage | Excel Worksheet Functions |