thank you, that was helpful
and i apologize for my bad netiauette, im new and didnt know any better

"Don Guillett" wrote:

First, Please do NOT type in all caps in the subject or the message. It is
considered to be SHOUTING and very bad netiauette.
Try this.

=CEILING(G4,10)-1

--
Don Guillett
SalesAid Software

"BROCK8292" wrote in message
...
IM MAKING PRICE TAGS AND I WANT TO ROUND UP THE PRICES TO THE NEAREST #
ENDING IN EITHER 39,69, 0R 99
SO IF THE VALUE OF THE CELL WAS 1575 FOR EXAMPLE
I WOULD WANT TO ROUND IT UP TO 1599
IS THERE A FORMULA THAT CAN AUTOMATE THIS?