SOLVED

Rounding Numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-2354360%22%20slang%3D%22en-US%22%3ERounding%20Numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2354360%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20know%20what%20formula%20to%20use%20in%20rounding%20up%20to%2050%20or%20100%20while%20using%20IF%20function%20in%20the%20same%20cell.%3C%2FP%3E%3CP%3EFor%20example%3A%3C%2FP%3E%3CP%3E4349%20when%20rounded%20up%20to%2050%2C%20it%20will%20be%204350.%20roundup(cell%23%2C50%2F0)*100%3C%2FP%3E%3CP%3E4399%20when%20rounded%20up%20to%20100%2C%20it%20will%20be%204400.%20roundup(cell%23%2C100%2F0)*100%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20know%20what%20formula%20can%20be%20use%20on%20the%20same%20cell%20that%20will%20automatically%20determine%20which%20roundup%20formula%20from%20above%20will%20be%20used%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2354360%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2354375%22%20slang%3D%22en-US%22%3ERe%3A%20Rounding%20Numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2354375%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1053775%22%20target%3D%22_blank%22%3E%40aznald101%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20the%20CEILING%20or%20CEILING.MATH%20function%20for%20this%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DCEILING.MATH(A1%2C50)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ewill%20round%20the%20value%20of%20A1%20up%20to%20the%20nearest%20multiple%20of%2050.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I want to know what formula to use in rounding up to 50 or 100 while using IF function in the same cell.

For example:

4349 when rounded up to 50, it will be 4350. roundup(cell#,10/0)*10

4399 when rounded up to 100, it will be 4400. roundup(cell#,100/0)*100

 

I want to know what formula can be use on the same cell that will automatically determine which roundup formula from above will be used?

 

Thank you!

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@aznald101 

You can use the CEILING or CEILING.MATH function for this:

 

=CEILING.MATH(A1,50)

 

will round the value of A1 up to the nearest multiple of 50.

Thanks