upper round off to a multiple of a no.

[Bhaveeth_Singh]

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 · Accepted 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.

[#3]

Thank you