Rounding number to closest 50 or 100 on exel

  • Thread starter Thread starter Karl
  • Start date Start date
K

Karl

I can't seem to round a figure to the nearest 50 or 100.
Example: If I had a figure 210.00 I want this to round to
250.00 or if I had a figure 190.00 I want this to round
up to 200.00.

Another example 260.00 rounded to 300.00

Seems so simple but I can't seem to find a way.
Mabey Logic function?
I've tried Roundup ceiling, floor, and round functions
but can't seem to get it right.

Any suggestions would be greatly appreciated.

Karl
 
=CEILING(A1,50)

will do what you want


note that you subject line is misleading, you want to round up to the
closest 50
else 210 would round to 200

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Back
Top