barryoglesby
New Member
- Joined
- Oct 2, 2018
- Messages
- 1
Hello all!
MrExcel newbie here. I'm trying to create an If statement, I'm assuming an If statement, that can define a cell based on where it falls in a range of numbers. It's for housing development project.
I'm attempting to solve for the Status As shown below, if the resident earns above $72K, they classified as Very Low Income - if earned $82,500, they would qualify as Median Income, anything over $99,450 would classify as Market. Any help on this would be great!
Unit Income Status Extremely Low Very Low Income Low Income Median Income Moderate Income
$72,000 Low Income $30,800 $51,350 $82,200 $82,900 $99,450
Let me know if this is not clear - thanks again for any input.
MrExcel newbie here. I'm trying to create an If statement, I'm assuming an If statement, that can define a cell based on where it falls in a range of numbers. It's for housing development project.
I'm attempting to solve for the Status As shown below, if the resident earns above $72K, they classified as Very Low Income - if earned $82,500, they would qualify as Median Income, anything over $99,450 would classify as Market. Any help on this would be great!
Unit Income Status Extremely Low Very Low Income Low Income Median Income Moderate Income
$72,000 Low Income $30,800 $51,350 $82,200 $82,900 $99,450
Let me know if this is not clear - thanks again for any input.
