if statement for two columns

[dw700d]

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

GSCS	EPL	Source
TRUE	FALSE
TRUE	FALSE
FALSE	FALSE
FALSE	TRUE
FALSE	TRUE
FALSE	TRUE
FALSE	TRUE

[#2 · Accepted 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.