Hi,
I have my raw data in the attachment. I am trying to find a IF statement or Formula that gives me an answer of "Cleared" or "Not Cleared.
"If the customer name has same ITEM, and Amount in both Debit and Credit side then Line Item is cleared"
Hi,
I have my raw data in the attachment. I am trying to find a IF statement or Formula that gives me an answer of "Cleared" or "Not Cleared.
"If the customer name has same ITEM, and Amount in both Debit and Credit side then Line Item is cleared"
Try
=IF(SUMIFS(O:O,H:H,H3,I:I,I3)=SUMIFS(P:P,H:H,H3,I:I,I3),"Cleared","Not Cleared")
Thank you for your help. The formula work perfectly. But in raw data sometimes I might not have "customer name" and it will blank. And with current formula it still spits out the result as "Cleared" where it should be "Not Cleared"
See Attachment
Remove the reference to it thus:
=IF(SUMIFS(O:O,I:I,I3)=SUMIFS(P:P,I:I,I3),"Cleared","Not Cleared")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thank you for the rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Thanks for all the help
Hi Ali @ Usama
It appears that Usama wants to test two conditions, viz. Customer Name and Item, i.e. columns H&I hence specifying just I:I won't pick up the Customer Name.
The problem is because of H10 being blank.
Assuming that the dual comparison is indeed the case the formula in S3 needs to be
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Thank Richard for your help. Thank you all for help.
Is it possible you or someone here can assist with my other thread that I have a question about. I am almost to reaching my final result.
Thread Title
"Combining data into one String Pattern"
Go and bump the thread in question. There is no point in bumping this one. If anyone can help, they will.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks