L
Lady Excel
Are there any functions which will round numbers up to the nearest 50? eg.
50, 100, 150, 200, etc.
50, 100, 150, 200, etc.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
FARAZ QURESHI
Supposing your number is in A1. Try the following:
=IF(A1-FLOOR(A1,50)<25,FLOOR(A1,50),CEILING(A1,50))
=IF(A1-FLOOR(A1,50)<25,FLOOR(A1,50),CEILING(A1,50))
F
FARAZ QURESHI
If you need to Round UP only then use only:
=CEILING(A1,50)
=CEILING(A1,50)
J
JE McGimpsey
One way:
=ROUND(A1/50,0) * 50
=ROUND(A1/50,0) * 50
J
joeu2004
Are there any functions which will round numbers up
to the nearest 50? eg. 50, 100, 150, 200, etc.
You subject line says "round up to 50", which is different from "round
to the nearest 50". Which is it?
One way to round to the nearest 50:
=mround(A1,50)
If you get a #NAME? error, use Excel Help to find information on how
to use the MROUND function.
Alternatively:
=round(A1/50,0)*50
That also makes it easy to round up or down to a multiple of 50:
=roundup(A1/50,0)*50
=rounddown(A1/50,0)*50
One of those solutions should work for you.