J
johnsonsm
This is a typical problem where I have a column of numbers that when
rounded, do not total to what you see on the screen. Rather than using
the precision as displayed option in Excel, I would like to use a
formula that uses the ROUND function that rounds each cell prior to
summing. Is there a function or formula that would replace
=(ROUND(A1,0))+(ROUND(A2,0))+(ROUND(A3,))...etc? I have tried
ROUND(SUM(A1:A20),0) but this rounds after the cells have been summed.
Any thoughts?
Thanks in advance
rounded, do not total to what you see on the screen. Rather than using
the precision as displayed option in Excel, I would like to use a
formula that uses the ROUND function that rounds each cell prior to
summing. Is there a function or formula that would replace
=(ROUND(A1,0))+(ROUND(A2,0))+(ROUND(A3,))...etc? I have tried
ROUND(SUM(A1:A20),0) but this rounds after the cells have been summed.
Any thoughts?
Thanks in advance