C
covingj
I want to create a table with income figures and then look up values based on
household size that is calculated and then return the column lable. For
instance, a 4x4 table with family size 1, 2, 3, 4 and column lables of 100%,
125%, 150% and 175%. The grid is filled with income amounts at each
intersection.
100% 125% 150% 175%
1 500 625 750 875
2 1000 1250 1500 1750
3 1500 1875 2250 2625
4 2000 2500 3000 3500
I want to look up an income amount for a calculated household size (using a
count function), and return the column lable to show the percentage, so that
a household of three with income of $1800 will return a value of 125%
household size that is calculated and then return the column lable. For
instance, a 4x4 table with family size 1, 2, 3, 4 and column lables of 100%,
125%, 150% and 175%. The grid is filled with income amounts at each
intersection.
100% 125% 150% 175%
1 500 625 750 875
2 1000 1250 1500 1750
3 1500 1875 2250 2625
4 2000 2500 3000 3500
I want to look up an income amount for a calculated household size (using a
count function), and return the column lable to show the percentage, so that
a household of three with income of $1800 will return a value of 125%