I tried to post this once before but I realize now that I need to include
more detailed information.

I have a sheet with multiple tenant/rental information. In column G is a
move-in date. Column H has the move-in income and Column J has the household
size (1-8).
In Column I, I need to know the percent of median income at move-in.
I need the formula to analyze the data in all columns: G, H & J. If there is
1 person in the household, and they made less than $13800 a year at move in
and they moved in between 1995 and 2000, then the cell needs to read "30%".
The data is found on another table within the workbook. If that one person
made between $13801 and $23050, then the cell should read "50%". For the
years 2001-2007 there are separate tables for each year so the formula would
only have the one year to look at. I have been trying to figure this formula
out for WEEKS and I am just at my wits end.
In former IF formulas, I've had trouble with income around 50% and so have
used the ROUND feature to 2 places.

To say that any help would be appreciated is an understatement. Please help!

Thank you one and all for your time and effort on my behalf,
Leigh