End Result Based on Several Criterias

Try this in D2:

=IF(OR(B2="",C2=""),"-",IF(AND(B2="Deposit",C2="Reconciled"),A2,"-"))

This will show A2 in D2 only if both B2 is "Deposit" AND C2 is "Reconciled" - if you mean either of those then the AND should be replaced with OR. Also, you might want to change the "-" to zero (twice) if you are using an accounting format.

Hope this helps.

Pete

Thank you guys so much for your help!!!

Your both formulas work, however, sorry, might not explained myself properly - Deposit and Withdrawal needs to be blended formulas together (in same End Result cell)

I also just realized that I missed on one criteria - Cleared must also be added to a formula...

I tried figuring things out with what already was given, just not able to... Attaching a screenshot for better explanation to what I'm trying to achieve here.

2017-06-28_2005.png

Is it possible to take a look at it again? Just to tweak, we're almost there!

(can't seem to find the way to attach Excel file?)

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Seems to have figured out the way how to share Excel.

This link should work

https://www.excelforum.com/attachmen...1&d=1498671798

Try this:

=IF(AND(A2=200,B2="Deposit",C2="Reconciled"),A2,IF(AND(A2=200,B2="Withdrawal",C2="Reconciled"),-A2,IF(AND(B2="",C2=""),"-","-")))

What is purpose of "criteria 2" if either are valid with Criteria 1" : it is the latter which determines the outcome and is not (on my understanding) dependent on value of "Criteria 2".

Unless there are are other options for "Criteria 2"

Is this what is required ???.

=IF(OR(B7="",C7=""),"-",IF(AND(B7="Deposit",OR(C7="Reconciled",C7="Cleared")),D2,D3))

As you have drop-downs to control what can be entered in B7 and C7, you can use this formula in D7:

=IF(OR(B7="",C7=""),0,IF(B7="Deposit",A7,-A7))

I.e. no need to test directly for "Withdrawal".

Hope this helps.

Pete

Thanks! One criteria 'Cleared' is missing, as per earlier screenshot and a file I attached. Reattaching here again

https://www.excelforum.com/attachmen...as-erbosc.xlsx

This is it, Pete! Jeez, you guys great. Thank you so much!!!

You're welcome - it's always easier if you can see the workbook.

Thanks for marking the thread as Solved.

As you are relatively new to the forum, you might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete

Done, Pete, thank you for guidance too :-)