I am currently having trouble with using a nested if statement, I am thinking I may need to try a different statement to use, in order to generate what I am needing. I have provided two screen shots of what I am trying to accomplish. first is a usage rate. and the second is a min. capacity requirement. both are based on the user input of home sqft and number of bedrooms. the 2nd seems a little more in depth-in regards of the formula needed. any advise is welcomed, even if its just pointing me in the correct direction. Thank you !!
