How to round & sum only the displayed (rounded) numbers
On Fri, 19 Feb 2010 06:57:01 -0800, ALG wrote:
I have rounded some numbers to the thousands digits. I need help finding a
formula that rounds the displayed (rounded thousands) digits. Everything I
try only calculates it based on the unrounded numbers and as such many sum
numbers are off by 1 (or really 1,000). Any help would be awesome! thanks
It sounds as if you did NOT really round the numbers, but rather just changed
the formatting in the cells. To ROUND a number, you need to use the ROUND
function, or equivalent.
e.g.
A1: =your_formula
vs
A1: =ROUND(your_formula,2)
--ron
|