Hi all,
What i trying to do is to get zero balance amount based on three column. this three column got positive or negative amount.
As we can see on table below, when we sum amount H1 + G2, we will get balance 0.20 and that mean not zero balance.
but when we sum H3,G4,H5,F6 we can get 0 balance.
Row No Column F Column G Column H Resault 1 -1,033.40 No Match 2 1,033.60 No Match 3 -1,296.30 Match 4 1,201.40 Match 5 1,743.45 Match 6 -1,648.55 Match
i need help with formula.
here the attachment file.
thank you so much for helping me.
Bookmarks