ROUNDUP Function not working

%3CLINGO-SUB%20id%3D%22lingo-sub-2040139%22%20slang%3D%22en-US%22%3EROUNDUP%20Function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2040139%22%20slang%3D%22en-US%22%3E%3CP%3Eroundup%20will%20not%20work%20on%20my%20computer%20but%20the%20same%20formula%20works%20on%20other%20computers%20%26amp%3B%20mobile.%26nbsp%3B%3C%2FP%3E%3CP%3Ealso%20the%20comma%20is%20not%20showing%20up%20on%20my%20computer%20but%20is%20everywhere%20else.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22BrodieLaw_1-1610030153660.png%22%20style%3D%22width%3A%20369px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244733i20452F98DC60A42A%2Fimage-dimensions%2F369x197%3Fv%3D1.0%22%20width%3D%22369%22%20height%3D%22197%22%20role%3D%22button%22%20title%3D%22BrodieLaw_1-1610030153660.png%22%20alt%3D%22BrodieLaw_1-1610030153660.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22BrodieLaw_2-1610030220589.png%22%20style%3D%22width%3A%20244px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244734i6D927C284258D59A%2Fimage-dimensions%2F244x500%3Fv%3D1.0%22%20width%3D%22244%22%20height%3D%22500%22%20role%3D%22button%22%20title%3D%22BrodieLaw_2-1610030220589.png%22%20alt%3D%22BrodieLaw_2-1610030220589.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bcomputer%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20mobile%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2040139%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2040197%22%20slang%3D%22en-US%22%3ERe%3A%20ROUNDUP%20Function%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2040197%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F921168%22%20target%3D%22_blank%22%3E%40BrodieLaw%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EWhat%20is%20the%20list%20separator%20on%20your%20machine%3F%20If%20Windows%3C%2FP%3E%0A%3CP%3EWin%2BR%3C%2FP%3E%0A%3CP%3Econtrol%20international%3C%2FP%3E%0A%3CP%3EAdditional%20settings%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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_1-1610030153660.png             BrodieLaw_2-1610030220589.png

 

3 Replies

@BrodieLaw 

What is the list separator on your machine? If Windows

Win+R

control international

Additional settings

 

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

@Sergei Baklan 

@BrodieLaw , glad to help