SOLVED

if statement for two columns

New Contributor

Good day I am sure this is very simple but I just cant seem to figure it out.

I have two columns below "EPL" & "GSCS". I would like to create a third column called "Source" . In that column I would like to create a statement that says if the GSCS column is True then return the value GSCS. If the EPL value is true then return the value EPL. IF both are false the cell should remain blank.

*The GSCS and EPL Columns will never both be True*.

 

Thanks in advance for your help

 

 

 

GSCSEPLSource
TRUEFALSE 
TRUEFALSE 
FALSEFALSE 
FALSETRUE 
FALSETRUE 
FALSETRUE 
FALSETRUE 
1 Reply
Best Response confirmed by dw700d (New Contributor)
Solution

@dw700d Try this:

=IF(A2,$A$1,IF(B2,$B$1,""))

assuming that all of this is in columns A and B and the header is on row 1.