Formula Based on Table of Data

[Kelli]

I am trying to come up with a formula to return a value based on a table of
data. For instance, If student A has no siblings and their parent makes less
than 13K they qualify for free lunch, if they have 1 sibling the amount is
17K they qualify for free lunch. Any insight would be helpful.

Thank you in advance.

 

[Don Guillett]

Post your table and examples

 

[Jacob Skaria]

With your salaray in A1 and number of siblings in B1 try the below formula

In C1
=IF(OR(AND(A1<13000,0+B1=0),AND(A1<17000,0+B1=1)),"Free Lunch","Not eligible")

If this post helps click Yes