CODEWITHSUNDEEP
excelexcel-formula
jeanseb
jeanseb

Reputation: 1

Multiple Condition in Excel files

I am stuck with this table...

  A  B  C  D E
1 y     y    Orange

I would like to have the result in the Column E:

If A and C =y than = Orange

Thanks,

Steve V.

Upvotes: 0

Views: 37

Answers (1)

xris23
xris23

Reputation: 353

I think you need this:

=IF(AND(A1="y",C1="y")," Orange",IF(AND(A1="y",D1="y"),"Blue",IF(AND(B1="y", D1="y"),"Red", IF(AND(B1="y",C1="y"),"Black",IF nothing applies))

enter image description here

Upvotes: 1

Related Questions