| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MROUND formula problem, help please! | Excel Worksheet Functions | |||
| cannot open exsisting file | Excel Discussion (Misc queries) | |||
| Adding to an exsisting formula | Excel Discussion (Misc queries) | |||
| how do i add new sheets to an exsisting formula | Excel Discussion (Misc queries) | |||
| How can I insert a period into exsisting cells? | Excel Discussion (Misc queries) | |||
Linear Mode
