Ron,

Why not just:

=CEILING(A1,0.25)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Ron Coderre" wrote in message
...
Try this:

With a number in A1

This formula rounds that number up in multiples of 0.25
B1: =CEILING(A1/0.25,1)*0.25

Does that help?
***********
Regards,
Ron

XL2003, WinXP


"Neil Pearce" wrote:

In the questing below what I'm really asking I suppose is how do you
round a
number up to the nearest 0.25?