IF Length parameter

[mbiAK7WZ]

Hello again. 

I am currently making a family, and have problems with the IF parameter on the length. I need the paratmeter ''Altan bredde'' to have the length, 3290mm, 3380mm and so on up to 4500mm, but i cant get it to work and looked at many different sites to get to know how it can be done 

So far i have tried '' IF(length 3200mm, 3290mm, 3380mm) and IF(Altan bredde 3200mm, 3290mm, 3380mm) and IF(length < 3200mm, 3290mm, 3380mm) and IF(Altan bredde < 3200mm, 3290mm, 3380mm) 

I hope you can help

I have link the file here to. 

[mbiAK7WZ]

The file is attached here

[ToanDN]

I don't see Length parameter in your family.

[mbiAK7WZ]

Altan bredde, altan dybde should be length parameter, if i change the dimensions on them it changes the drawing, im far from done with parameters, but i need to get If length parameter on the dimensions i mentioned.

If you have a solution to make the parameter the way you are thinking, then i am open for it

Thanks

[ToanDN]

Let's say, if you input the value 3320, do you want the length to become 3290 or 3380?

[mbiAK7WZ]

3380

[ToanDN · Accepted solution]

Add Length_Input parameter.  Your formula for Altan Bredde should be like this:

if(or(Length_Input<3200,Length_Input=3200), 3200,

if(or(Length_Input>3200,Length_Input<3290,Length_Input=3290),3290,

if(or(Length_Input>3290,Length_Input<3380,Length_Input=3380),3380, 

...

4500)))

The ... is for you to continue to develop until it reaches 4500.

By the way, your family is super heavy.

[mbiAK7WZ]

 it makes this messege when i put in the parameter

[ToanDN · Accepted solution]

See my revised formula. Yours is missing the last value 4500 so the syntax is incomplete.  copy paste ithe one below to yours.

if(or(Length_Input<3200,Length_Input=3200), 3200,if(or(Length_Input>3200,Length_Input<3290,Length_Input=3290),3290,if(or(Length_Input>3290,Length_Input<3380,Length_Input=3380),3380, 4500)))