roundup: to the nearest FIVE?

[RobPhenix]

Well, the subject heading pretty much states the question: Can I configure ROUNDUP to work to the next highest FIVE instead of whole number? Or is there any other function I can use to make Excel do this for me?
Like if the answer to a formula is 2.30, I'd like it to change the answer to 5.00.
Is this possible? THANKS!
Rob

 

[PaddyD]

HI -welcome to the board!

=CEILING(A1,5)

paddy

 

[Yogi Anand]

Hi RobPhenix:

Welcome to the Board!

Use =CEILING(A1,5)

Regards!
Yogi Anand

 

[VoG]

For info this also works

= 5*ROUNDUP(A1/5,0)

Here are general functions that will round to whatever you want

Function RdUp(Nmber As Variant, Nearest As Integer)
RdUp = Nearest * Application.RoundUp(Nmber / Nearest, 0)
End Function

Function RdDn(Nmber As Variant, Nearest As Integer)
RdDn = Nearest * Application.RoundDown(Nmber / Nearest, 0)
End Function
This message was edited by VoG™ on 2002-11-07 18:11

 

[RobPhenix]

Wow! Fast responses, and I even get the answer I want: YES, it CAN be done!
Thanks, all, that is fantastic!
Rob W.