Thread: Dividing with decimals in answer (ie. batting averages)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default 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.


Reply With QuoteReply With Quote