Thread: Round numbers to get to the nearest 0.09
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Round numbers to get to the nearest 0.09
On Mon, 23 Nov 2009 12:44:02 -0800, KB wrote:

How do I round numbers to get to the nearest 0.09
(4.17=4.19 or 4.12=4.09)

=ROUND(A1+0.01,1)-0.01
--ron
Reply With QuoteReply With Quote