View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default =ROUNDUP(INT(0.xxx))

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



Dave F wrote:

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.


--

Dave Peterson