rounddown

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jnf - 16 Mar 2006 13:27 GMT

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

Reply to this Message

AndyB - 16 Mar 2006 13:34 GMT

Hi

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

Andy.

> 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

Reply to this Message

jnf - 16 Mar 2006 19:11 GMT

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

> Hi
>
[quoted text clipped - 5 lines]
> > ie 1.6 to 1 or 1 to 1
> > thanks jnf

Reply to this Message

AndyB - 17 Mar 2006 10:15 GMT

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 your help,the problem i am getting is when i use either int
> or
[quoted text clipped - 11 lines]
>> > ie 1.6 to 1 or 1 to 1
>> > thanks jnf

Reply to this Message

jnf - 17 Mar 2006 14:16 GMT

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

> It can't!! It just chops off the fraction bit.
>
[quoted text clipped - 19 lines]
> >> > ie 1.6 to 1 or 1 to 1
> >> > thanks jnf

Reply to this Message

joeu2004@hotmail.com - 16 Mar 2006 13:46 GMT

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

Reply to this Message