View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BROCK8292 BROCK8292 is offline
external usenet poster
 
Posts: 29
Default CAN I ROUND TO THE NEAREST # ENDING IN 99 FOR EXAMPLE

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?