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 41 weeks ago
6 years 27 weeks ago
6 years 39 weeks ago
6 years 42 weeks ago
6 years 43 weeks ago
6 years 48 weeks ago
7 years 4 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago
7 years 5 weeks ago