| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dividing Cells & Averages | Excel Discussion (Misc queries) | |||
| What function would let me find Batting Averages? | Excel Worksheet Functions | |||
| What function would let me find Batting Averages? | Excel Worksheet Functions | |||
| What function would let me find Batting Averages? | Excel Worksheet Functions | |||
| What function would let me find Batting Averages? | Excel Worksheet Functions | |||
Linear Mode
