Round whole numbers up and down

J

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
 
J

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
 
B

Bob Phillips

CEILING and FLOOR DO work

=FLOOR(232,10) - answer 230

--

HTH

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

swatsp0p

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

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

Thanks
 
Top