Allrightythen!
Try this:
=IF(SUM(G4:H4)=0,"Company Direct",IF(G4=1,"Partnered on Brand
X","Partner Direct"))

In English it says if they're both zero write "Company Direct",
otherwise if G4 is 1 then write "Partnered on Brand X" otherwise (ie,
not both zero and not a 1 in G4) write "Partner Direct"
That will work as long as those are the only 3 possibilities.

On May 9, 5:47 pm, AnnArborBrian
wrote:
Also, there are a couple of conditions that are "Mixed" where some business
units on the account are "Partnered", and some are Partner Direct, such that
both columns G and H have 1, and I need to return to Column I the statement
"Mixed"

"AnnArborBrian" wrote:
I have 3 conditions defined across 3 columns of data, each with 0's or 1's
depending on partnership status of an account. If all three conditions /
columns are 0, then it is a company direct account. I want to consolidate
the date into 1 column (Company Direct, Partnered on Brand Y, Partnered on
Brand X, Partner Direct).

Would someone please suggest a formula for this, I rarely work with Excel
and it is a Friday . . .