Excel IF function with multiple conditions/outcomes

Question

How would this be written as a nested IF function:

If single
  a. give <20 = "Bachelor"
  b. give >20 = "Big Donor"
If married**
  a. give <20 = "Frugal Double"
  b. give >20 = "Charity Couple"

Aleksey Kiselev · Accepted Answer · 2016-10-12 00:03:12Z

1

= IF(A2="Single",IF(C2<20,"Bachelor","Big Donor"),IF(C2<20,"Frugal Double","Charity Couple"))

where A2 could have "Single" or other value (add other validation if needed) and C2 could have any number as a value (add other validation if necessary)

Hope that will help

answered Oct 12, 2016 at 0:03

Aleksey Kiselev

3311 gold badge7 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel IF function with multiple conditions/outcomes

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related