rounddown

J

jnf

how do i round down the number contents of a cell to a complete digit
ie 1.6 to 1 or 1 to 1
thanks jnf
 
J

joeu2004

jnf said:
how do i round down the number contents of a cell to a
complete digit ie 1.6 to 1 or 1 to 1

Try searching Help for "round down" or simply "round".
You will discover ROUNDDOWN(). One answer to your
question is ROUNDDOWN(...,0).

PS: Note that there is a difference between INT() and
ROUNDDOWN() for negative numbers.
 
J

jnf

hi thanks for your help,the problem i am getting is when i use either int or
roundown it trims of the decimal piont but when it is a full digit ie 1 it
puts it to 0
thanks jnf
 
G

Guest

It can't!! It just chops off the fraction bit.

It could be that the number is actually less than 1 - but is formatted to
show 0 decimal places. If the number was 0.9966 and was formatted to show 0
decimal places, it would display 1 but an INT() on it would give you 0

Andy.
 
J

jnf

hi thanks for help, you are right i have tried it with a clean number and it
works, i think my problem is it could be a calculation from antother cell
thank jnf
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top