User Profile
bkishishita
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
IF Functions
Hi, I have the following chart and looking to create a formula that solves for the rent amount if 2 conditions are met - (the AMI and the Unit Type both match to solve for the rent that corresponds in the table). For example, IF (specified cell="60%" AND specified cell="Efficiency" then $906), OR if (specified cell="60%" and specified cell="1 Bedroom" then $970). Any guidance would be appreciated. Thank you.
