"nekteo via OfficeKB.com" wrote:
Running down 22.2 to 22 by using "=roundown (B2,0)"
works just fine for me untill i want to run 22 to 21.
How to do that?

Are you saying that you want 22+fraction to round down
to 22 __and__ you want 22 (exactly) to round down to 21
-- in the same formula?

More generally, are you saying that you want n+fraction
to round to n and you want n to round to n-1 in the same
formula?

Doesn't make much sense to me; that is, I cannot think of
a problem where that is the correct solution. But if that's
what you want, the following should do the trick:

=IF(INT(A1)=A1, A1-1, ROUNDDOWN(A1,0))

Caveat: What do you want -22 to "round down" to: -21
or -23? The above would go to -23. But -21 is consistent
with ROUNDDOWN(), which rounds "toward zero". If you
want -21, then the following works, giving 21 for A1=22
and -21 for A1=-22:

=IF(INT(A1)=A1, A1 - SIGN(A1), ROUNDDOWN(A1,0))