CODEWITHSUNDEEP
excelxlsx
alvkat
alvkat

Reputation: 33

Multiple IF AND statements in Excel

How would I combine both of these points into one nestled IF AND statement all in one column?

  1. If B6 is "Alone" and N6 is >= 20 then "Donor" if not "Single"
  2. If B6 is "Partnered" and N6 is >= 20 "Charity" if not "Frugal"

Upvotes: 2

Views: 2028

Answers (1)

Hambone
Hambone

Reputation: 16397

If B6 is "Alone" and N6 is >= 20 then "Donor" if not "Single"

 =if(and(B6="Alone",N6>=20),"Donor","Single")

If B6 is "Partnered" and N6 is >= 20 "Charity" if not "Frugal"

 =if(and(B6="Partnered",N6>=20), "Charity", "Frugal")

If you need to combine multiple if's (more than two possibilities):

=if(condition1,true value,if(condition2, true value, false value))

But I didn't see anything that had that type of logic chain in your example.

-- Edit --

Okay, now I see what you are trying to do. Try this:

=IF(B6="Alone",IF(N6>=20,"Donor","Single"),IF(B6="Partnered",
    IF(N6>=20,"Charity","Frugal"),""))

Upvotes: 1

Related Questions