View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Rounding Off decimals to the lowest number

Maybe this:

=ROUNDDOWN(A1,0)

HTH,
Paul

--

"eric" wrote in message
...
I'm trying set up bowling handicapping program...like 80% of 220, which is
220 is 0. now if i do the next one (219) it gives me a decimal number (.8)
i
want every decimal number to be rounded to the lowest number, in this case
to
zero.