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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!