divide column(x) by column(y) to give column(x/y) in excel?

J

James

I'm trying to divide one column by another column to give me another column
of awnsers as in B1/C1=D1, B2/C2=D2 etc... Is this possible?
Thanks
 
E

Elkar

In cell D1 enter the following formula:

=B1/C1

Copy this formula down column D as far as you need. The cell references
will increment automatically.

HTH,
Elkar
 

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

VBA Coding Help for Beginner 0
Scatter graphs, excel 11 mac user 0
Consistent Sheet column header rows 2
column to row draging 1
Autonumber field in Excel that behaves the same as Access 0
Calculating column A * column B = Results in another column 2
Creating a line graph with recurring Y values 0
X,Y,Z values to be extracted and posted respectively in excel 5

Top