=ceiling(a1,25)
"Mac" wrote in message
...
I am working on a worksheet where I am doing orders, if I have an order of
anything over a whole number I need to round it up to 25 more. So 26 would
need to be 50, etc. If it's 25 I need it to be 25 or if its 12 I need for
it
to be 25, 51 would need to be 75, etc. How do I go about doing this?
|