apply function to multiple cells

M

MrXXX

Hi,
So I want to write a function which divides every value in column A b
the corresponding value in column B and I don't feel like monkey typin
the formula in every cell. How can I apply this formula to all cells?
I want column C to look like this. Do I need to write a loop o
smthing?
A1/B1
A2/B2
A3/B3

Thank
 
P

Pete_UK

In cell C1 enter the formula:

=A1/B1

and format the cell how you want it to look (percentage?). Then select
this cell and double-click the fill handle - the small black square in
the bottom right hand corner. The formula will automatically be copied
down column C for the extent of your data in column B.

Hope this helps.

Pete
 
Top