Thread: Round numbers to get to the nearest 0.09
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
  
Posts: 5,934
Default Round numbers to get to the nearest 0.09
I think this will do what you want...

=ROUND(A1,1)-0.01

--
Rick (MVP - Excel)


"KB" wrote in message
...
How do I round numbers to get to the nearest 0.09
(4.17=4.19 or 4.12=4.09)

Reply With QuoteReply With Quote