Working formula
=IF(M6="","",IF(OR(AND(N6="",M6<$Q$2),AND(N6>0,N6-M6>0)),"NO","YES"))
Need to add new criteria if Q5 = Open then return a blank
=IFS((M5="","",Q5="Open",""),(IF(OR(AND(N5="",M5<$Q$2),AND(N5>0,N5-M5>0)),"NO","YES")))
Working formula
=IF(M6="","",IF(OR(AND(N6="",M6<$Q$2),AND(N6>0,N6-M6>0)),"NO","YES"))
Need to add new criteria if Q5 = Open then return a blank
=IFS((M5="","",Q5="Open",""),(IF(OR(AND(N5="",M5<$Q$2),AND(N5>0,N5-M5>0)),"NO","YES")))
I'm not familiar with IFS and IF combinations.
As far as i can find out, there is no combination with IF within an IFS formula.
Perhaps you should make a nested IF formula to do the trick.
Just make sure you got the priorities right to get the requested result.
Maybe this could be of help
Please Login or Register to view this content.
Even a little help can be a big help !!
1. A sample workbook says more then words. Add problem description and solution so we can understand the problem.
2. Your appreciation is accepted by clicking the star "Add Reputation" at the lower left of the post.
3. If your problem is solved, mark it as [SOLVED]: See "FAQ : " https://www.excelforum.com/faq.php
4. Use [CODE] [/CODE] tags to illustrate your code: see here
Brian, if you are using Excel 2010, as your profile shows, you do not have the IFS function.
If the suggestion from post #2 doesn't work as expected for you after substituting the semicolons for commas, consider uploading a small representative sample of your data along with the desired results based on that sample.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks