medium10 pts · first answer countsexcelrounding

Rounding prices up to the next ₹5

Prices like ₹121, ₹123 and ₹125 must be rounded up to the next multiple of ₹5 (125, 125, 125). Which formula does this?

A.=ROUND(A2,5)B.=CEILING.MATH(A2,5)C.=ROUNDUP(A2,-1)+5D.=MROUND(A2,10)

Discussion 0

Join free to post in the discussion.