try this one !!!

=IF(MOD(H23,10)0,CEILING(H23,5)-
(AND(MOD(H23,10)<10,MOD(CEILING(H23,5),10)=0)),IN T((H23/5)+1)*5)



On Jun 3, 11:12*am, Dala wrote:
Hi.

I found this in a post when searching.
The solution was provided by Bob Phillips back in 2006.

=CEILING(A10,5)-(AND(MOD(A10,10)<0,MOD(CEILING(A10,5),10)=0))

What it does, is to round up to a 5, 9 or 0, depending on the data.
This was exactly what was needed for that post in 2006.
Example
11 = 15
14 = 15
16 = 19
18 = 19
19 = 19
20 = 20
21 = 25

I need the same thing, but not when it comes to *0 = *0

What I need is
11 = 15
14 = 15
16 = 19
18 = 19
19 = 19
20 = 25
21 = 25

Bobs explanation can be found at

http://www.microsoft.com/office/comm....mspx?dg=micro...

Is it possible that someone could modify this formula, or perhaps suggest
another one for me?
I seem to have no luck.

Grateful for any help!

BR

/Dala