View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default MROUND an exsisting formula?

Looking in the help index for MROUND at example 4 should give you a clue.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jerid B" wrote in message
...
I have a cell that states: =N61*1.1
The number comes out correct.
Can I use MRound in this forumula to say:
=N61*1.1 but now take that number and round it to the nearest 5 cents?
Example= $11.88. I would like it to be $11.90

Is this possible?