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 Picture #2 is mobile

BrodieLaw What is the list separator on your machine? If Windows Win+R control international Additional settings

JimjdhfNte On your computer, the list separator is the same as the decimal symbol: you use comma for both. That causes the conflict. Either use comma as decimal symbol and semicolon as list separator, or point as decimal symbol and comma as list separator.

Thanks for the help! This worked just had to change it back to a comma.SergeiBaklan

Your answer didn't work for me SergeiBaklan what could I be doing wrong?

Forum Discussion

BrodieLaw

Copper Contributor

Jan 07, 2021

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

Picture #2 is mobile

roundup test.xlsx8 KB

excel

17 Replies

SergeiBaklan
Diamond Contributor
Jan 07, 2021
BrodieLaw

What is the list separator on your machine? If Windows

Win+R

control international

Additional settings
- BrodieLaw
  Copper Contributor
  Jan 07, 2021
  Thanks for the help! This worked just had to change it back to a comma.
  SergeiBaklan
  - SergeiBaklan
    Diamond Contributor
    Jan 07, 2021
    BrodieLaw , glad to help