Thanks! We'll email you
when relevant content is
added and updated.
Using Sum on a column of currency of 2 decimal positions. Using IF to compare that Sum total to another total. To my knowledge, all cells are defined a 2 decimal postions.
Some value entries result in the Sum total having a "1" in the 10 decimal position and some value entries do not result in the Sum total having a "1" in the 10th decimal position. When viewed, both totals look identical with 2 decimal postions. The If formula results in an False response because of the "1" in the 10th decimal position. Subtracting the two totals results in a zero result regardless of the number of decimal positions displayed.
November 20, 2013 8:29 PM