Is there a way to write a formula that will raise a flag to if row data for household size AND ...

Deanna Vandermeer

I am trying to write a formula that will raise a flag if the row data fits specific criteria for determining income eligibility for a project. Basically it would be if the data on that row in the household size equals a number and if the annual gross income is less than or equal to a dollar amount, we need it to raise the flag. This would also need to be a nested IF statement (I believe) to help accomplish all of the scenarios. Here is a screenshot of the charge we need to refer to for the dollar amount to household size. Any help would be greatly appreciated as I am currently stuck on how to accomplish this or even if this is a formula that can be done. Thank you.

RossL

I think you would need to put an INDEX/MATCH into your If statement to look at a table that has you income levels matched up to your household size.

Deanna Vandermeer

I will give that a try.

Deanna Vandermeer

RossL - just a question, if I do an Index/Match from the table, how do I account if the income falls below for each household size?