Dividing with decimals in answer (ie. batting averages)
 

How do you divide and get more than just an integer? I would like to have
team statistics and calculate batting averages to three decimal places.

Dividing with decimals in answer (ie. batting averages)
 

Hits divided by at bats

A1 = hits 3
B1 = at bats = 9

=ROUND(A1/B1,3)

Custom format as .000

--
Biff
Microsoft Excel MVP


"Kenosha" wrote in message
...
How do you divide and get more than just an integer? I would like to have
team statistics and calculate batting averages to three decimal places.

Dividing with decimals in answer (ie. batting averages)
 

highlight the column or row your data will be in...

Go to Format Cells Number and ensure it is set to Number.

Change Decimal Places to 3.

Although, to truly look like a batting average, you should drop the leading
0. You can then click on Custom and remove the 0 prior to the .

"Kenosha" wrote:

How do you divide and get more than just an integer? I would like to have
team statistics and calculate batting averages to three decimal places.

Dividing with decimals in answer (ie. batting averages)
 

Thanks. That worked with the decimal placement, but I can not get 7 divided
by 2 to be .285.

"Sean Timmons" wrote:

highlight the column or row your data will be in...

Go to Format Cells Number and ensure it is set to Number.

Change Decimal Places to 3.

Although, to truly look like a batting average, you should drop the leading
0. You can then click on Custom and remove the 0 prior to the .

"Kenosha" wrote:

How do you divide and get more than just an integer? I would like to have
team statistics and calculate batting averages to three decimal places.

Dividing with decimals in answer (ie. batting averages)
 

Kenosha

7 divided by 2 is 3.5 .... but 2 divided by 7 is .285714. Set to 3 places
you get .285

Mike Rogers

"Kenosha" wrote:

Thanks. That worked with the decimal placement, but I can not get 7 divided
by 2 to be .285.

"Sean Timmons" wrote:

highlight the column or row your data will be in...

Go to Format Cells Number and ensure it is set to Number.

Change Decimal Places to 3.

Although, to truly look like a batting average, you should drop the leading
0. You can then click on Custom and remove the 0 prior to the .

"Kenosha" wrote:

How do you divide and get more than just an integer? I would like to have
team statistics and calculate batting averages to three decimal places.

Dividing with decimals in answer (ie. batting averages)
 

Thanks. That solved the decimal problem. I still can not get 2 divided by 7
to be more than an integer and be .285 rather than .000.

"Sean Timmons" wrote:

highlight the column or row your data will be in...

Go to Format Cells Number and ensure it is set to Number.

Change Decimal Places to 3.

Although, to truly look like a batting average, you should drop the leading
0. You can then click on Custom and remove the 0 prior to the .

"Kenosha" wrote:

How do you divide and get more than just an integer? I would like to have
team statistics and calculate batting averages to three decimal places.

Dividing with decimals in answer (ie. batting averages)
 

What formula is used to get those results? Quotient only provides an integer.

"Mike Rogers" wrote:

Kenosha

7 divided by 2 is 3.5 .... but 2 divided by 7 is .285714. Set to 3 places
you get .285

Mike Rogers

"Kenosha" wrote:

Thanks. That worked with the decimal placement, but I can not get 7 divided
by 2 to be .285.

"Sean Timmons" wrote:

highlight the column or row your data will be in...

Go to Format Cells Number and ensure it is set to Number.

Change Decimal Places to 3.

Although, to truly look like a batting average, you should drop the leading
0. You can then click on Custom and remove the 0 prior to the .

"Kenosha" wrote:

How do you divide and get more than just an integer? I would like to have
team statistics and calculate batting averages to three decimal places.

Dividing with decimals in answer (ie. batting averages)
 

Did you not see my reply?

--
Biff
Microsoft Excel MVP


"Kenosha" wrote in message
...
What formula is used to get those results? Quotient only provides an
integer.

"Mike Rogers" wrote:

Kenosha

7 divided by 2 is 3.5 .... but 2 divided by 7 is .285714. Set to 3
places
you get .285

Mike Rogers

"Kenosha" wrote:

Thanks. That worked with the decimal placement, but I can not get 7
divided
by 2 to be .285.

"Sean Timmons" wrote:

highlight the column or row your data will be in...

Go to Format Cells Number and ensure it is set to Number.

Change Decimal Places to 3.

Although, to truly look like a batting average, you should drop the
leading
0. You can then click on Custom and remove the 0 prior to the .

"Kenosha" wrote:

How do you divide and get more than just an integer? I would like
to have
team statistics and calculate batting averages to three decimal
places.

Dividing with decimals in answer (ie. batting averages)
 

Kenosha

with 2 in A1 and 7 in B1 Formula is =A1/B1

Format cell via: format cellscustom in the "type box enter .000 and ok out

Mike Rogers



"Kenosha" wrote:

Thanks. That solved the decimal problem. I still can not get 2 divided by 7
to be more than an integer and be .285 rather than .000.

"Sean Timmons" wrote:

highlight the column or row your data will be in...

Go to Format Cells Number and ensure it is set to Number.

Change Decimal Places to 3.

Although, to truly look like a batting average, you should drop the leading
0. You can then click on Custom and remove the 0 prior to the .

"Kenosha" wrote:

How do you divide and get more than just an integer? I would like to have
team statistics and calculate batting averages to three decimal places.

Dividing with decimals in answer (ie. batting averages)
 

What is your cell format and formula? What does =ISNUMBER(cell) return when
cell points to each input and the cell with the formula? If it returns
FALSE, what does =LEN(cell) return?

Your reported results taken at face value appear to rule out the obvious
problems, but =2/7 in Excel returns 0.285714, which when rounded to 3 decimal
places is 0.286. If you want 0.285, you probably intend
=ROUNDDOWN(2/7,3)

Jerry

"Kenosha" wrote:

Thanks. That solved the decimal problem. I still can not get 2 divided by 7
to be more than an integer and be .285 rather than .000.

"Sean Timmons" wrote:

highlight the column or row your data will be in...

Go to Format Cells Number and ensure it is set to Number.

Change Decimal Places to 3.

Although, to truly look like a batting average, you should drop the leading
0. You can then click on Custom and remove the 0 prior to the .

"Kenosha" wrote:

How do you divide and get more than just an integer? I would like to have
team statistics and calculate batting averages to three decimal places.