Your question, your audience. Choose who sees your identity—and your question—with question security.
=IF(LEFT(L2,2)="CF","SMC","") & " " & IF(M2="No Dupe",IF(LEFT(K2,3)="FDC","FDC",""),"")
= IF (A1 = A2, A2, "")
instead of= IF (A1 = A2, A2)
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Link how? Create just one formula that has all the IF statements? Is the logic of the order the same as in your question? If so, you can just nest the formulas in that order.
But you already use nested IFs, so you know how to do this.
What is the processing logic for each of the "false" parts of your formulas above?
cheers, teylyn