Formula chaining IFs and ANDS

[dwackerX6C3B]

Hello Everyone,

I have a text parameter I'm trying to manipulate using formulas. However, I'm having some struggles.

What I am trying to accomplish, simplified, is:

If Height < 38" and Depth < 24" = "LE1"

If Height > 38" and Depth < 24" = "LE2"

If Height > 38" and Depth > 24" = "LE3"

I attempted this by using the following formulas:

IF ( AND (Depth < 2’, Height < 3’ 2”), “LE1”, (IF ( AND (Depth < 2’, Height > 3’ 2”), “LE2”, “LE3”)))

&

IF (Depth < 2', "LE2", IF (AND (Depth < 2’, Height <3’ 2”), “LE1”, “LE3”))

Neither of these worked for me and I am unsure why. 

Thank you for any help you can provide!

[RDAOU · Accepted solution]

With double double you are missing conditions

• Height < 38" and Depth > 24"
• Height =38 and Depth=24
• Height = 38 and Depth < 24
• Height = 38 and Depth > 24
• Height > 38 and Depth = 24
• Height < 38 and Depth = 24

What happens when the  condition one of the above? Assuming they would included under any other value than the defined, which would be LE4, the statement would look as follows

if(and(Depth < 24", Height < 38"), "LE1", if(and(Depth < 24", Height > 38"), "LE2", if(and(Depth > 24", Height > 38"), "LE3", "LE4")))

if(and(Depth < 24", Height < 38"), "LE1", if(and(Depth < 24", Height > 38"), "LE2", if(and(Depth > 24", Height > 38"), "LE3", "LE4")))

The question remains...What would you wish that text to be  for the other conditions when ...the above includes it as others value as set LE4. YOu might need to add some ORs in there or additional IFs

[dwackerX6C3B]

That would be "LE2" also.

So something along the lines of this? 

IF ( AND (Depth < 2’, Height < 3’ 2”), “LE1”, (IF ( AND (Depth < 2’, Height > 3’ 2”), “LE2”, (IF ( AND (Depth > 2’, Height < 3’ 2”), “LE2”, “LE3”))))

REVIT still doesn't like it, stating "The following is not a valid parameter: 2'"

[RDAOU]

@dwackerX6C3B 

change units to inch instead feet & inch...  and paste the following

if(and(Depth < 24", Height < 38"), "LE1", if(or(and(Depth < 24", Height > 38"), and(Depth > 2", Height < 38")), "LE2", if(and(Depth > 24", Height > 38"), "LE3", "LE4")))

Unless you want to include them under LE1, LE2 and LE3 the above accounts for the remaining conditions as other LE4

• Height =38 and Depth=24
• Height = 38 and Depth < 24
• Height = 38 and Depth > 24
• Height > 38 and Depth = 24
• Height < 38 and Depth = 24

if(and(Depth < 24", Height < 38"), "LE1", if(or(and(Depth < 24", Height > 38"), and(Depth > 2", Height < 38")), "LE2", if(and(Depth > 24", Height > 38"), "LE3", "LE4")))