=IF(OR(AND(A1="one sibling",B1<17000),AND(A1="no
sibling",B1<13000)),"qualify","no qualify")


"Kelli" wrote:

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.