Thread: Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mitch Mitch is offline
external usenet poster
 
Posts: 88
Default Formulas

How can I apply a formula to (an) entire column(s), with results applied to
individual rows? For instance, if I want every row to divide column D by C
and enter the result in column E. Do I have to enter the formula for each
and every row using the "=D2/C2" formula in the E2 column, then "=D3/C3" in
the E3 column, etc., one at a time?

I hope I'm being clear!

Thanks