View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tieske Tieske is offline
external usenet poster
 
Posts: 14
Default =ROUNDUP(INT(0.xxx))

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.