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.

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.

=FLOOR(formula,0)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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.

i appreciate your help it works ...thanks

"Bob Phillips" wrote:

=FLOOR(formula,0)

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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.

"PCLIVE" wrote:

Maybe this:

=ROUNDDOWN(A1,0)

HTH,




thank you so much, it works ...i combined your suggestion with bob and it
works perfectly
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.