timothy.savage@snhu.edu's blog

If(AND nested statement

I am trying to figure out how to create a nested if/and statement with 5 conditions but I either get an effor telling me it is not a valid equation or it tells me I have too many conditions. Below is the formula.

Essentially I would like the cell to tell me, based on the five conditions, if it is less than or more than fair market rent for the size of unit (0-4 bedrooms) and the corresponding rent standard.

Here is my statement

Syndicate content