Round whole numbers up and down

[JoeBed]

I have a cell that has a whole number.I want round it to the nearest muliple of 5.
Examples:
231 round down to 230
232 round down to 230
233 round up to 235
234 round up to 235
235 = 235
236 round down to 235
237 round down to 235
238 round up to 240
239 round up to 240
240 =240
and so on
Is there a formula to do this. Ceiling and Floor does not work.
Thanks for any help
Joe

[JoeBed]

Please disregard the post. I found my answer in a previous post. When I did a search, I couldn't find it. I found my answer by luck on page 2. T
Thanks Joe

[swatsp0p]

Try using MROUND, as such:

=MROUND(A1,5)

does this work for you?

Bruce

[Bob Phillips]

CEILING and FLOOR DO work

=FLOOR(232,10) - answer 230

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JoeBed" <[email protected]> wrote in
message news:[email protected]...
>
> I have a cell that has a whole number.I want round it to the nearest
> muliple of 5.
> Examples:
> 231 round down to 230
> 232 round down to 230
> 233 round up to 235
> 234 round up to 235
> 235 = 235
> 236 round down to 235
> 237 round down to 235
> 238 round up to 240
> 239 round up to 240
> 240 =240
> and so on
> Is there a formula to do this. Ceiling and Floor does not work.
> Thanks for any help
> Joe
>
>
> --
> JoeBed
> ------------------------------------------------------------------------
> JoeBed's Profile:
http://www.excelforum.com/member.php...o&userid=21368
> View this thread: http://www.excelforum.com/showthread...hreadid=384539
>

[swatsp0p]

Please disregard the post. I found my answer in a previous post. When I did a search, I couldn't find it. I found my answer by luck on page 2. T
Thanks Joe

Could your share your findings for others that read your thread?

Thanks,