EGADS!!!......ROUNDDOWN acts that way too!

Just shows how often I use them like that and how much attention I don't pay.

Vaya con Dios,
Chuck, CABGx3



"tony h" wrote:


I agree with the previous answers but just check it does what you want
with negatives.
I think roundup is a misnomer as it actually rounds-away-from-zero. so
roundup(-0.5,0) gives -1. I would expect from the name roundup that
-0.25 would go UP to 0 and -1.25 would go up to 1

regards


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=532565