Round up numbers to set values

[baggers719]

I have a list of numbers I'm trying to round up.

For example I am trying a hlookup for a list of items such as

8.1, 8.23, 7.97, 8.55

The above numbers should round up to the nearest quarter.

I.e. 8.1 = 8.25, 8.23 = 8.25, 7.97=8.0, 8.55=8.75.

Any ideas?

Thanks!

Sean.

 

[mikerickson]

Try
=ROUNDUP(A1*4, 0)/4

 

[Fluff]

How about
=CEILING(A2,0.25)