apply function to multiple cells

  • Thread starter Thread starter MrXXX
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Averageifs - criteria is cell is not blank 1
Very strange behaviour of VLOOKUP in Excel 2010 4
Data Validation and drop-down list using IF, AND and what else? 8
Countif function giving incorrect answer 5
sum working hours each month (sum hours in the last row for a monthin a table with dates) 3
Building closed workbook file path within an Index Function 6
Show other cell if blank 5
Figuring out a lengthy formula. Probably quite simple... 3

Back
Top