View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AnnArborBrian AnnArborBrian is offline
external usenet poster
 
Posts: 5
Default Conditional Result based on Multiple Columns

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 . . .