You know...I didn't even catch that. I guess I'm still half asleep. :)

In article ,
"Bob Phillips" wrote:

I love the way the subject says round up to the nearest 10, whilst the body
says the nearest 5 <G

Bob


"Domenic" wrote in message
...
Try...

=CEILING(A1,5)

Hope this helps!

In article ,
"Marek" wrote:

Does anyone have any ideas on how to round up to the nearest 5. For
example,
107.55 would round up to 110
53.55 would round up to 55