rounddown

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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.
 
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
 
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.
 
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
 
Back
Top