Formula Based on Tables

  • Thread starter Thread starter Kelli
  • Start date Start date
K

Kelli

I am trying to write a formula that will return a value based on a table of
data. For instance if student A has no siblings and an income less than 13K,
they qualify for free lunch. I the student has one sibling and they make
less than 17k, they qualify for free lunch, etc.

Any help would be greatly appreciated.
 
=IF(OR(AND(A1="one sibling",B1<17000),AND(A1="no
sibling",B1<13000)),"qualify","no qualify")
 
Back
Top