Rounding Numbers

T

trimatt

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
 
K

KL

Hi,

Try the following formulae:

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

Regards,
KL
 
Top