I do not want my numbers rounded up. I would like them to round down if they
are a decimal of .5 or higher. Can this be done. If so, how?

Thanks for you help

Hi,

Try the following formulae:

=FLOOR(A1,1)
=ROUNDDOWN(A1,0)
=INT(A1)
=TRUNC(A1,0)

Regards,
KL


"trimatt" wrote in message
...
I do not want my numbers rounded up. I would like them to round down if
they
are a decimal of .5 or higher. Can this be done. If so, how?

Thanks for you help

Use the ROUNDDOWN function, or INT function

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"trimatt" wrote in message
...
I do not want my numbers rounded up. I would like them to round down if
they
are a decimal of .5 or higher. Can this be done. If so, how?

Thanks for you help