Try this:

=CEILING(A1+0.01,1)-0.01

--
Biff
Microsoft Excel MVP


"WBTKbeezy" wrote in message
...
Hello, does anyone know if a function will work so that I can round a
number
UP to the nearest ending of .99? So if a number is 7.60 it would round to
7.99 or if a number is 7.01 it would round to 7.99?