C
cheeser83
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.
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.