| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=ROUNDUP(INT(0.xxx))
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=ROUNDUP(INT(0.xxx))
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: 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=ROUNDUP(INT(0.xxx))
Yes, you're right, I did mean =ROUNDUP(INT(0.999),0)
Thanks. -- Brevity is the soul of wit. "Dave Peterson" wrote: =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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=ROUNDUP(INT(0.xxx))
Thanks Marcelo and Dave for helping me keep my sanity.
-- Brevity is the soul of wit. "Marcelo" wrote: 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: 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. |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
=ROUNDUP(INT(0.xxx))
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 "Dave F" wrote in message ... Thanks Marcelo and Dave for helping me keep my sanity. -- Brevity is the soul of wit. "Marcelo" wrote: 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: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
