View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Roundup to .99 endings

mj99 wrote:
Trying to get every number in an excel file to roundup for retail price
points....
20.34 = 20.99
38.75 = 38.99


=INT(price) + 0.99

That will change $20 to $20.99. Is that what you want?