Thread: How can you round numbers to the nearest quarter (i.e. .63=.75)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elkar Elkar is offline
external usenet poster
  
Posts: 964
Default How can you round numbers to the nearest quarter (i.e. .63=.75)
MROUND does still exist, but it is part of the Analysis ToolPak, so that must
be installed for it to work.

In Excel 2003 or earlier:
TOOLS--OPTIONS--ADD-INS--Check "Analysis ToolPak"

In Excel 2007:
OFFICE Button--Excel Options--Add-Ins--GO Button--Check "Analysis ToolPak"

Also, you may want to take a look at the CEILING and FLOOR functions.

HTH,
Elkar

"EM" wrote:

there used to be an MROUND function that did this but I don't think excel has
it anymore. Any suggestions?
Reply With QuoteReply With Quote