=ROUNDUP(INT(0.xxx))
Why post this? I don't know, maybe because this is a discussion group?
Or are you one of those "best to be seen and not heard" people?
--
Brevity is the soul of wit.
"Tieske" wrote:
why post this??? Yes that's correct int(0.9999) will return only the integer
part, being 0.
"Dave F" wrote in message
...
This function should always return 0, correct?
Ex.: =ROUNDUP(INT(0.9999)) is really =ROUNDUP(0)
A colleague claims this is a bug in Excel; I claim this is correct.
Dave
--
Brevity is the soul of wit.
|