Excel Help?

Posted By Message

azoodie

Member since 8/05

8377 total posts

Name:
Team SEXY BACK

Excel Help?

Okay I am a self-proclaimed excel dummy. I looked it up but still can't figure out how to do this.

Say I want to divide column a by column b and have it appear in c....

what is the function for that? what do I highlight? everything i try is only displaying one answer in one cell. does this make sense?

Posted 4/12/07 2:46 PM
 
Long Island Weddings
Long Island's Largest Bridal Resource

LadyPrincess
Live Life with No Regrets

Member since 5/05

2298 total posts

Name:
Chris

Re: Excel Help?

put cursor in column C (where you want the answer)

then

=sum(column A1 / column B1)

Chat Icon

Message edited 2007-04-12 14:49:22.500000.

Posted 4/12/07 2:48 PM
 

LaurenExp
Waiting patiently for baby sis

Member since 8/06

11613 total posts

Name:
L-Diddy EDD 11/11/11 :)

Re: Excel Help?

Just put the formula:

=a1/b1 in the c1 column. You can copy that formula all the way down the column by dragging that little black box in the right-hand corner of the cell.

HTH.

Posted 4/12/07 2:48 PM
 

MrsERod
Praying for Everyone.

Member since 5/05

26170 total posts

Name:
MrsERod™®

Re: Excel Help?

with the cursor in cell c, hit the sum button at the top (looks like an E)

then click on column a

add /

then click on column b


the field at the top should appear like this

=SUM(A1/B1)


1 represents the line # you're on, so that will vary

Posted 4/12/07 2:49 PM
 

azoodie

Member since 8/05

8377 total posts

Name:
Team SEXY BACK

Re: Excel Help?

Posted by LaurenExp

Just put the formula:

=a1/b1 in the c1 column. You can copy that formula all the way down the column by dragging that little black box in the right-hand corner of the cell.

HTH.



WOW!!! That was it!! Thank you so much!! Who knew there was a black box there? Chat Icon

Posted 4/12/07 2:52 PM
 
 

Potentially Related Topics:

Topic Posted By Started Replies Forum
where can i download microsoft excel for free?? w/no viruses? raken40 10/24/05 3 Families Helping Families ™
Need help with Excel and Word - Mass Mailings Marcie 8/4/06 9 Families Helping Families ™
Excel file to pdf? KPtoys 5/1/06 13 Families Helping Families ™
Dumb excel question JenniferEver 4/23/06 3 Families Helping Families ™
Excel Question MsG 4/17/06 5 Families Helping Families ™
PowerPoint and Excel.. LBG30 10/18/05 6 Families Helping Families ™