MROUND an exsisting formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MROUND 4
Round Down to the nearest multiple 2
MROUND time 2
Mround to nearest 5 c 1
MROUND(F2,TIME(0,0,5)) 2
Rounding numbers 5
rounding up to nearest specified whole number 1
Round formula 1

Back
Top