ranjansmail
New Member
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 not sure what I am missing here, it seems like a bug. Any clues!!!
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 not sure what I am missing here, it seems like a bug. Any clues!!!