Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
I am using the MROUND function to display a series of number like 1622 as 1500. The problem I am having is that I am summing all of these cells and it sums the newly rounded number. What I would like to happen is the individual cells to display the rounded number but have the cell with the SUM in it display the sum of the actual, unrounded number. Is there a way to do this? Any help is much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mround function equivalent that does not require "add-in" | Excel Discussion (Misc queries) | |||
Why are german users getting an error with Mround? ATP installed. | Excel Worksheet Functions | |||
Mround to nearest 5 c | Excel Discussion (Misc queries) | |||
MROUND function. Getting the following error: #NAME? | Excel Worksheet Functions | |||
MROUND function disappears | Excel Discussion (Misc queries) |