PDA

View Full Version : 2014 Formulas for an Array



kmarquis
2015-06-19, 04:33 PM
Is there any way I can set up an integer so that when the user types in a number of mullions that it can be less than 2? I know arrays can't be less than 2 but I'm trying to do this with a few yes/no parameters but it's not really working. I'm thinking something like if Vertical Mullions is less than 2 turn on the single mullion but I can't elegantly link it to the multiple array without the user having to check a few boxes.

kmarquis
2015-06-19, 05:05 PM
I got it! I made a new integer and set up the formula for the multiple array Integer like this

if(Vertical Mullions>2, Vertical Mullions, 2). It works! Which basically means if it's less than 2 force it to be 2, otherwise make it what it is (which is any other number). If it's a 0 the integer defaults to 2, if it's a 3 or a 4 the integer is a 4. If it's a 1, the single instance of the mullion turns on and the multiple array turns off.