=ROUNDDOWN(A1,-2)+IF(MOD(A1,100)<39,39,IF(MOD(A1,100)<69,69,99))

.... and please don't SHOUT.
--
David Biddulph

"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?