timothy.savage@snhu.edu's blog
If(AND nested statement
Submitted by timothy.savage@... on 19 October, 2012 - 21:07I 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

Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago