creating a function for dividing two columns

[cflan]

I am trying to keep track of softball stats. I trying to make a column of
batting averages. I have at bats in column b, hits in column c with the
results in column d. I cant get the function right so it will display the
correct result.

 

[Steve H.]

use this =SUM(C1/B1) in cell D1. Format D1 as a number with 3 decimal
places.

Steve Hubbard

 

[Lady Layla]

Say you have information in B3 and C3 --- in D3 enter =C3/B3 Expand the # of
decimal points to your needed #


: I am trying to keep track of softball stats. I trying to make a column of
: batting averages. I have at bats in column b, hits in column c with the
: results in column d. I cant get the function right so it will display the
: correct result.

 

[Lady Layla]

No need for =SUM =C1/B1 will work just fine


: use this =SUM(C1/B1) in cell D1. Format D1 as a number with 3 decimal
: places.
:
: Steve Hubbard
:
:
: : > I am trying to keep track of softball stats. I trying to make a column of
: > batting averages. I have at bats in column b, hits in column c with the
: > results in column d. I cant get the function right so it will display the
: > correct result.
:
:

 

[cflan]

I have tried all that I still get an error in my formula, I am not sure I am
using the right function. My first columns contain 29 and 18 which should get
me .621. The result won't show in the next column.

 

[Frank Kabel]

Hi
what have you EXACTLY entered in WHICH cell?

 

[Lady Layla]

If 29 is in Cell B3 and 18 is in cell C3, in Cell D3 enter =C3/B3 Format to 3
decimal places ---- mine comes up 0.621

What exactly is showing in your spreadsheet?



: I have tried all that I still get an error in my formula, I am not sure I am
: using the right function. My first columns contain 29 and 18 which should get
: me .621. The result won't show in the next column.
:
: "Lady Layla" wrote:
:
: > Say you have information in B3 and C3 --- in D3 enter =C3/B3 Expand the #
of
: > decimal points to your needed #
: >
: >
: > : > : I am trying to keep track of softball stats. I trying to make a column of
: > : batting averages. I have at bats in column b, hits in column c with the
: > : results in column d. I cant get the function right so it will display the
: > : correct result.
: >
: >
: >

 

[cflan]

Thanks Lady Layla, I figured it out, anyway to make it do the whole column at
once instead of each one. thanks

 

[Lady Layla]

Just copy D3 and paste down, it will adjust the row numbers for you


: Thanks Lady Layla, I figured it out, anyway to make it do the whole column at
: once instead of each one. thanks
:
: "Lady Layla" wrote:
:
: > If 29 is in Cell B3 and 18 is in cell C3, in Cell D3 enter =C3/B3 Format
to 3
: > decimal places ---- mine comes up 0.621
: >
: > What exactly is showing in your spreadsheet?
: >
: >
: >
: > : > : I have tried all that I still get an error in my formula, I am not sure I
am
: > : using the right function. My first columns contain 29 and 18 which should
get
: > : me .621. The result won't show in the next column.
: > :
: > : "Lady Layla" wrote:
: > :
: > : > Say you have information in B3 and C3 --- in D3 enter =C3/B3 Expand the
#
: > of
: > : > decimal points to your needed #
: > : >
: > : >
: > : > : > : > : I am trying to keep track of softball stats. I trying to make a column
of
: > : > : batting averages. I have at bats in column b, hits in column c with
the
: > : > : results in column d. I cant get the function right so it will display
the
: > : > : correct result.
: > : >
: > : >
: > : >
: >
: >
: >

 

[Gord Dibben]

In D1 enter =C1/B1

100 bats with 25 hits gives .250 average.

Make sure you know the rules about which is an official "at bat" and an
official "hit".

Gord Dibben Excel MVP

 

[cflan]

Lady Layla, thanks for all your help