Dividing with decimals in answer (ie. batting averages)

[Kenosha]

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.

 

[T. Valko]

Hits divided by at bats

A1 = hits 3
B1 = at bats = 9

=ROUND(A1/B1,3)

Custom format as .000

 

[T. Valko]

Hits divided by at bats

A1 = hits 3
B1 = at bats = 9

=ROUND(A1/B1,3)

Custom format as .000

 

[Sean Timmons]

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 .

 

[Sean Timmons]

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]

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

 

[Kenosha]

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

 

[Mike Rogers]

Kenosha

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

Mike Rogers

 

[Mike Rogers]

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]

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.

 

[Kenosha]

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.

 

[Kenosha]

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

 

[Kenosha]

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

 

[T. Valko]

Did you not see my reply?

 

[T. Valko]

Did you not see my reply?

 

[Mike Rogers]

Kenosha

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

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

Mike Rogers

 

[Mike Rogers]

Kenosha

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

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

Mike Rogers

 

[Jerry W. Lewis]

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

 

[Jerry W. Lewis]

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