Thread: Is there a formula to round a number to the nearest .09?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Is there a formula to round a number to the nearest .09?
=ROUND(A2+0.01,1)-0.01
--
David Biddulph

"WenMess" wrote in message
...
I'm trying to round to the nearest .09 (i.e., 1.46 would be 1.49). Is
there a
formula/function that would do this?


Reply With QuoteReply With Quote