ROUNDUP not working properly

[Roncondor]

Hi

In Excel2019 lately have been receiving incorrect results from the ROUNDUP function. Many times it does not Round up but down

on the attached, I used it without even a formula: just a hardcoded number, and I received an incorrect result

What is odd is that right underneath it shows the 1 that I expect, but the function result and the cell show a zero

Thank you

PS no circular references in the spreadhsheet

 

[BillDW]

Is it possible that you have some unusual formatting for that cell? You said that many times it rounds down, but does it sometimes round correctly? Can you try a copy>paste special>format from a cell that works to one that doesn't?

I can duplicate your results using a custom number format of "0.00000" (including the quotes), but that always returns 0.00000 - never anything else - and I don't know why anyone would have a cell formatted that way.

This probably isn't it, but it's the only thing I can think of that would cause the results you're seeing.

 

[Roncondor]

Is it possible that you have some unusual formatting for that cell? You said that many times it rounds down, but does it sometimes round correctly? Can you try a copy>paste special>format from a cell that works to one that doesn't?

I can duplicate your results using a custom number format of "0.00000" (including the quotes), but that always returns 0.00000 - never anything else - and I don't know why anyone would have a cell formatted that way.

This probably isn't it, but it's the only thing I can think of that would cause the results you're seeing.

View attachment 55118

Thank you. I switched to the INT formula instead of ROUNDUP. I don't think I had any unusual or custom formatting, but I will keep an eye out for that if it ever pops up again

 

[Joe4]

Thank you. I switched to the INT formula instead of ROUNDUP. I don't think I had any unusual or custom formatting, but I will keep an eye out for that if it ever pops up again

That doesn't seem to do what you want.
The INT function will never round up, it will always round down, as it just removes the decimal portion on the number.
Or are you then adding one to the answer, as long as it doesn't start off as a whole number, i.e.

=IF(A1=INT(A1),A1,INT(A1)+1)

 

[Alex Blakenburg]

I am sure this is unlikely but when you put in constants into the ROUNDUP function arguments screen was the ActiveCell actually blank ?

I can reproduce your screen in my 365 but only I have a value (in my case -1) in the activecell when I invoked fx > ROUNDUP dialogue box.

 

[Roncondor]

That doesn't seem to do what you want.
The INT function will never round up, it will always round down, as it just removes the decimal portion on the number.
Or are you then adding one to the answer, as long as it doesn't start off as a whole number, i.e.

=IF(A1=INT(A1),A1,INT(A1)+1)

Thanks -will check that it works ok.