Hi
It depends what you are trying to achieve.
=ROUNDDOWN(B2,0) will always return the same value as
=INTEGER(B2)
=TRUNC(B2)
if you are wanting the next integer below the value in B2 then
=ROUNDDOWN(B2,0)-1
=INTEGER(B2)-1
If it is some multiple of 21, then maybe
=INTEGER(B2/21)*21
=TRUNC(B2/21)*21
--
Regards
Roger Govier
"nekteo via OfficeKB.com" <u17073@uwe wrote in message
news:5a5afa35e918f@uwe...
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?
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200601/1