Excel rounding question
 

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?

=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?

Try this

=IF(MOD(A1,25)=0,A1,A1-MOD(A1,25)+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?