HOW DO I SELECT A RATE FROM A TABLE
There is no column mentioning the 'income' slabs...If you mean to get the
figures based on the # in household you can use the below formula..If not
post back with an example of what you are looking for....
=LOOKUP(numberinhousehold,A2:A5,B2:B5)
If this post helps click Yes
---------------
Jacob Skaria
"mdwgno" wrote:
how do i select a status from a table or array based on # in household and
income "less than" such as the following:
# in household Free Reduced
1 13520 19240
2 18200 25900
3 22880 32560
4 27560 39220
|