| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Based on Table of Data
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 --------------- Jacob Skaria "Kelli" wrote: 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create list based on data table | Excel Discussion (Misc queries) | |||
| Pivot Tables with different groupings based on same data table | Excel Discussion (Misc queries) | |||
| Pivot Tables with different groupings based on same data table | New Users to Excel | |||
| Formatting Data Pasted from Web Based Table for Summation | Excel Discussion (Misc queries) | |||
| Create Charts based on data in Table | Charts and Charting in Excel | |||
Threaded Mode
