Formula Based on Table of Data

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

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.
 
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
 
Back
Top