=ROUNDUP(INT(0.xxx))

D

Dave F

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
 
D

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.
 
T

Tieske

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

Marcelo

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:
 
D

Dave F

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?
 
E

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.
 
Top