SOLVED

upper round off to a multiple of a no.

%3CLINGO-SUB%20id%3D%22lingo-sub-1606171%22%20slang%3D%22en-US%22%3Eupper%20round%20off%20to%20a%20multiple%20of%20a%20no.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606171%22%20slang%3D%22en-US%22%3E%3CP%3Ea%20was%20using%20excel%20and%20wanted%20to%20get%20an%20upper%20roundup%20of%20a%20no.%20and%20get%20it%20to%20a%20nearest%20multiple%20of%20a%20no%20of%20my%20desire%20but%20i%20am%20not%20able%20to%20find%20the%20correct%20formula%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1606214%22%20slang%3D%22en-US%22%3ERe%3A%20upper%20round%20off%20to%20a%20multiple%20of%20a%20no.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1606214%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F768030%22%20target%3D%22_blank%22%3E%40Bhaveeth_Singh%3C%2FA%3E%26nbsp%3B%2C%26nbsp%3Bi%20think%20the%20formula%20that%20you%20are%20seeking%20is%20CEILING.%20In%20it%2C%20you%20can%20specify%20the%20number%20and%20the%20significance%20for%20rounding%20up.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22amit_bhola_1-1598163400487.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F214123i8325469F3E71D730%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22amit_bhola_1-1598163400487.png%22%20alt%3D%22amit_bhola_1-1598163400487.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1620452%22%20slang%3D%22en-US%22%3ERe%3A%20upper%20round%20off%20to%20a%20multiple%20of%20a%20no.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1620452%22%20slang%3D%22en-US%22%3EThank%20you%3C%2FLINGO-BODY%3E
New Contributor

a was using excel and wanted to get an upper roundup of a no. and get it to a nearest multiple of a no of my desire but i am not able to find the correct formula

 

2 Replies
best response confirmed by cuong (Microsoft)
Solution

@Bhaveeth_Singh , i think the formula that you are seeking is CEILING. In it, you can specify the number and the significance for rounding up.

 

amit_bhola_1-1598163400487.png

 

Thank you