Thread: rounding numbers
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default rounding numbers
Note that MROUND requires the Analysis ToolPac to be installed
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cin" wrote in message
...
Use
=MROUND(3.4,0.5)
Where 3.4 can also be the cell refernce.

"VPHR" wrote:

How can I round 3.4 to 3.5 instead of 3.0 or 4.0?


Reply With QuoteReply With Quote