Forum Discussion
BrodieLaw
Jan 07, 2021Copper Contributor
ROUNDUP Function not working
roundup will not work on my computer but the same formula works on other computers & mobile. also the comma is not showing up on my computer but is everywhere else. Picture #1 is computer Pictur...
BrodieLaw
Jan 07, 2021Copper Contributor
Thanks for the help! This worked just had to change it back to a comma.
SergeiBaklan
Jan 07, 2021Diamond Contributor
BrodieLaw , glad to help
- Urban_ChampionSep 01, 2023Copper Contributor
Your answer didn't work for me SergeiBaklan what could I be doing wrong?
- SergeiBaklanSep 02, 2023Diamond Contributor
Could you please give more details - what is the formula exactly and under "not work" do you mean some error message or result you don't expect.
- Urban_ChampionSep 02, 2023Copper Contributor
Yes, I get the normal "There's a problem with this formula" message... What I need to achieve is that if a resultant answer has a decimal, I need it to round up to the NEXT whole number. Not the NEAREST whole number. So if the answer is 11.32, I need it to round up to 12. SergeiBaklan
This is the error I'm getting. The normal roundup formula isn't working.