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 16:52:47 -0500, "Rick Rothstein"
wrote:

No, you are not missing anything... adding the 0.01 to the value inside the
ROUND function as you show in your post is the correct way to do this.

--
Rick (MVP - Excel)


Sometimes, in those hours between the start of cocktail time and dinner, I've
been known to miss things :-)
--ron