=ROUNDUP(INT(0.xxx))

[Guest]

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

 

[Dave Peterson]

=roundup() takes two arguments.

If you mean:
=ROUNDUP(INT(0.9999),0)

then 0 looks like the only correct answer to me.

=int(0.9999) will be 0
=roundup(0,0) will still be 0.

 

[Tieske]

why post this??? Yes that's correct int(0.9999) will return only the integer
part, being 0.

 

[Guest]

hi Dave,

this is correct, excel use the math rules to do the operations, Int(0.9999)
= 0
roundup 0 will always be 0.

if you do the formula like =int(roundup((0.9999),0)) will be 1

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Dave F" escreveu:

 

[Guest]

Yes, you're right, I did mean =ROUNDUP(INT(0.999),0)

Thanks.

 

[Guest]

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?

 

[Guest]

Thanks Marcelo and Dave for helping me keep my sanity.

 

[Epinn]

Dave F,

Thank you for the post. Interesting thread to highlight the difference between

=INT(ROUNDUP((0.9999),0))
and
=ROUNDUP(INT(0.9999),0)

I hope the forum "police" is not around when I post my questions.

Epinn

Thanks Marcelo and Dave for helping me keep my sanity.