Thread: Need formula to round number up to always end in X.X9
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Need formula to round number up to always end in X.X9
Try the below

=CEILING(A1,0.1)-0.01

If this post helps click Yes
---------------
Jacob Skaria


"Heather" wrote:

I have a spreadsheet with prices. If the price is 2.55, I want the formula
to round it up to 2.59. If it is 3.01, I want the formula to round it to
3.09. The last digit always needs to be a 9, and it always needs to round UP
to the next .x9. Any ideas?
Reply With QuoteReply With Quote