I would like to both combine these 3 if statements so that it can be placed into one cell.
=IF((AND(A2<>"",C2="Variation Parent")),A2,"")
OR
=IF((AND(A2<>"",C2="Variation Child")),A2,"")
OR
=IF((AND(C2<>"",C2<>"RelationType",C2<>"Variation Parent",C2<>"Variation Child")),B1,"")
I would also like to simplify any unnecessary repetition within these statements.
I know that the first two lines should be able to be simplified because they both return the same true and false values, but I'm not sure how to do that.
I also know that the third line is just a bunch of things that are not equal to C2, so isn't there a way to simplify all of those?
I don't know much else that can be done to simplify it though, but if anyone knows anything else, please let me know and if possible, show me how.
Just to clarify though, simplification is not the main priority here; combining these 3 lines into one working statement is what I really need.
Thanks in advance.
Bookmarks