Help with ROUNDDOWN/rounding task

[rdm]

Hi,

I've been trying to apply the ROUNDDOWN(_,0) function to a table of values. I want it to round down partial numbers such as 3.5 to 3.0, but not whole numbers such as 3.0 to 2.0. I want those to stay as the same value if there are integers.

How can I write my statement to do so?

Thanks

[Fotis1991]

Hi and welcome to the forum.

Try

=INT(A1)

[rdm]

Hi and welcome to the forum.

Try

=INT(A1)

Thanks for the welcome. Unfortunately that didn't work as it still rounds 13.0 down to 12.0. Any other ideas?

[zbor]

It can not round 13 to 12 as it take out all decimal places and leave just whole number.

More likely your 13 is not 13 but something like 12.9999 (where INT will give 12 but showing number to 2 decimal will show 13).

[Fotis1991]

Why?? I can not understand it.


Edit: Good morning Zbor. I did not see your post before mine!!

[zbor]

Fotis, in your example in first cell now enter 12.99 and you'll find out why

[Fotis1991]

Yes my friend... I understand what you mean...

But it's 12.99(I mean if you type it)..... Not 13 ! Isn't it?

[zbor]

Yes. But it's showed as 13. And making INT of that can bring a confusion.
So it's more important to see what's in the cell, and now what is showed there.

[icestationzbra]

with TRUNC function:

12.99 > 12
3.5 > 3
3.0 > 3

[rdm]

It can not round 13 to 12 as it take out all decimal places and leave just whole number.

More likely your 13 is not 13 but something like 12.9999 (where INT will give 12 but showing number to 2 decimal will show 13).

You are right. I expanded the cells to show 3 decimal places and the INT function worked the way it was supposed to after doing this. Thanks a lot for the help