I have simple check formula to make sure if the sum of parts is equal to whole .
The formula works fine when I give data in certain sequence but fails when the sequence is changed . See the excel work book for better idea.
http://www.mediafire.com/file/a1drjct9uvy7f36/Excel%20Bug.xls
I am...