Thread
:
MROUND an exsisting formula?
View Single Post
#
1
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett