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

Hi

You could use =INT(A1) to chop off the decimal part of the number.

Andy.

"jnf" wrote in message
...
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" wrote:
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.

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

"AndyB" wrote:

Hi

You could use =INT(A1) to chop off the decimal part of the number.

Andy.

"jnf" wrote in message
...
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

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.

"jnf" wrote in message
...
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

"AndyB" wrote:

Hi

You could use =INT(A1) to chop off the decimal part of the number.

Andy.

"jnf" wrote in message
...
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

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

"AndyB" wrote:

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.

"jnf" wrote in message
...
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

"AndyB" wrote:

Hi

You could use =INT(A1) to chop off the decimal part of the number.

Andy.

"jnf" wrote in message
...
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