Thread: Round numbers to get to the nearest 0.09
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default Round numbers to get to the nearest 0.09
With a bit of playing around I came up with
=ROUND(A1,1) - 0.01
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"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