### Title

Too Many Parameters....another solution?

### Post

I am working on an equation that has too many parameters and need a fresh look. Anyone suggest another way? Here is the gist of what I am trying to do:

1f [(BoxA > 80 and BoxB< 90) AND If (ContainerA >120 and ContainerB<150);"Perfect";"not Perfect"]

I need to to get a range between two different groups to get a result. I tried the IF statement above and get a TOO MANY PARAMETERS error. I also need to nest 4 of these If statements in the equation to accommodate different ranges and results.

Is there another way?

==== EDITED ABOVE... should look like this======

1f [(BoxA > 80 and BoxA< 90) AND If (ContainerA >120 and ContainerA<150);"Perfect";"not Perfect"]

Would that be two different results or 4?

Case ( BoxA >90 and BoxA<110 AND ContainerA>150 and ContainerA<180 ; "Result 1" ;

BoxA >110 and BoxA<120 AND ContainerA>180 and ContainerA<190 ; "Result 2" ;

"Result 3" // This is the "else" result returned when none of the two Boolean expressions are True

)

Case functions start with the first Boolean expression and returns the corresponding result of the first one to evaluate as True

PS, you probably need some

<operators here as the values BoxA = 110 and ContainerA = 180 will produce "Result 3" if you don't use them here.