Excel - Round to .99?

Asked By WBTKbeez on 13-Nov-07 12:37 PM
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?




WBTKbeez replied on 13-Nov-07 12:47 PM
I found the answer after searching further. Sorry for posting!
T. Valko replied on 13-Nov-07 10:23 PM
Try this:

=CEILING(A1+0.01,1)-0.01

--
Biff
Microsoft Excel MVP