ExcelBanter - problem with adding columns of numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - problem with adding columns of numbers (https://www.excelbanter.com/excel-worksheet-functions/9013-problem-adding-columns-numbers.html)

jeri_g

problem with adding columns of numbers

In a worksheet I have a series of numbers in a row tabulating a percentage.
In the last column I want the percentages added and displayed below. I used
SUM to add the proper cells and yet the total displayed is off by $0.02. Any
ideas why?

JE McGimpsey

Take a look at

http://www.mcgimpsey.com/excel/pennyoff.html

In article ,
jeri_g wrote:

In a worksheet I have a series of numbers in a row tabulating a percentage.
In the last column I want the percentages added and displayed below. I used
SUM to add the proper cells and yet the total displayed is off by $0.02. Any
ideas why?

All times are GMT +1. The time now is 09:41 PM.