IF, THEN across multiple columbs

[dmelanson]

Hello,

I'm looking to create a function that looks across multiple scenarios to give one output. In the screenshot below, columns A-F are going to be data that is hard coded and column G is going to be the output. For example, if column A is different than column D, output should be "GL". If column B is different than column E, output should be "CC". If both column A and B are different than D and E, output should be "GL/CC" and if both of the columns are the same then output should be "NULL". I put in IF formulas for each row, however I can't figure out how to include them altogether. I've been having a lot of trouble with this so any help would be much appreciated!

Thank you!

 

[etaf]

IF(AND(A1=D1,B1=E1),"",IF(AND(A1<>D1,B1<>E1), "GL/CC", IF( A1<> D1 , "GL", "CC")))
I think that should do what you asked