MROUND an exsisting formula?
 

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?

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?

MROUND an exsisting formula?
 

=MROUND(N61*1.1,0.05)


"Jerid B" wrote:

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?