| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use Mround when calculating the following (B2+C2)/3
How to use MROUND when calculation on a cell that is alreay performing a
calculation such as below (b2+c2)/3 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use Mround when calculating the following (B2+C2)/3
"Calvin" wrote:
How to use MROUND when calculation on a cell that is alreay performing a calculation such as below (b2+c2)/3 Whadaya want to MROUND it to? The following example MROUNDs to a multiple of 0.05: =MROUND((b2+c2)/3, 0.05) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MROUND | Excel Discussion (Misc queries) | |||
| MROUND | Excel Discussion (Misc queries) | |||
| MROUND | Excel Discussion (Misc queries) | |||
| MRound | Excel Discussion (Misc queries) | |||
| Mround | Excel Discussion (Misc queries) | |||
Linear Mode
