This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Can you please explain what do you exactly mean by "Overlapping"? Do you want these if else statements to be linked together using "AND" or "OR"? Can you provide some data sample and what do you expect your output to be?
Please try the below formula and let me know if this is what you are looking for
IF [A]!=0 AND [AT]= "0" THEN "ABD"
ELSEIF [STM]="DSW" THEN "BDC"
ELSEIF [ASW]=0 and [DFS]<5 THEN "DS" ELSEIF [SSMD]<5 THEN ""FGHFHR"
If yes then I believe the formula you are using is correct just need to change the priorities as you can see the row 4 satisfy the criteria Manual !=0 and GT-Manual=0 that is why it takes the status as Open Item just switch line 1 and 2 and it will work as it will give first priority to Record MJE then although it satisfy the condition mentioned earlier.
Also you need to prioritise the if else condition if two rows satisfy same condition and you are applying another condition to the same row then priority should be given as per the logic or end result you are looking for.
I hope this solves your query.
If yes, then kindly mark this post as solution.
IF [Right_SO-Fset-Eset]= "Reserve for Parts--" THEN "Record MJE" elseif [Manual]!=0 AND [GT-Manual]= 0 THEN "Open item" Elseif [SL Solution]="Aged item-Reservs booked with no amortization for 180 days from ATD1" THEN "Open Item-Aged" Elseif [SL Total]=0 and [Grand Total]<5 THEN "Open item_Closed order" Elseif [Grand Total]=0 and [SL Total]=0 THEN "Open item_Closed order" Elseif [GL vs SL]= 0 THEN "Record_Matched" Elseif [GL vs SL] > 5 THEN "Open Item" ELSE "" ENDIF