Rounding with no Decimals...

[Confused Man]

Hello all,

I have a cell set up to show a number with no decimals. With decimals the
number should be 5555.9854... but when I set it up to show no decimals it
returns 5556. is there a way to tell it not to round the whole number at
all?

Thanks so much,
Confused Man

 

[Dodo2u]

Hello all,

I have a cell set up to show a number with no decimals. With decimals
the number should be 5555.9854... but when I set it up to show no
decimals it returns 5556. is there a way to tell it not to round the
whole number at all?

Use ROUNDDOWN

 

[Karthik]

You can also use
=INT( ) function

=int(5555.9854) Result 5555

Karthik Bhat
Bangalore

 

[Bob Phillips]

That doesn't round though, it truncates.