View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
 
Posts: 1,231
Default Round to .05 or .09

Bruce wrote...
How can I round prices to the nearest 0.05 or 0.09?

Eg 1
5.01 to 4.99
Eg 2
4.44 to 4.45


Meaning the last digit would always be either a 9 or a 5?

to 0.09: =ROUND(x,1)-0.01

to 0.05: =ROUND($A1,1)-0.05

Note: using the first, 5.04 rounds down to 4.99; using the second, 4.