Goal amount for this year: 2500 USD, Received: 1627 USD (65%)

1. ## Formula issue

I have a family which has a parameter controlling the length but I have another parameter calculating off that as well as 4 other params based on whether they are turned on or off.

I have the formula working for two items but need to add the other 2.

Roof Panel Span = Span Calc + if([3rd End Plate On.Off], 180 mm, if([2nd End Plate On.Off], 90 mm, 0 mm))

What I need to introduce is:

If 2nd End Plate is on then I need to +45mm
and
If 2nd Top Plate is on then I need to +45mm
and
If 3rd End Plate is on then I need to +45mm
and
If 3rd Top Plate is on then I need to +45mm

So if all are on, then it will be +180mm
If one is on, then it will be +45mm
If two are on, then it will be +90mm
If three are on the it will be +135mm

I've tried a few formulas but not abel to nail it.

Can anyone help?

2. Originally Posted by GarethCavill
Can anyone help?
First, Are they your parameter names verbatim? 3rd End Plate On.Off

Second, are the square brackets solely a typo here? You need to be using parenthesis in all places.

Otherwise there's nothing wrong with your method of nesting ifs... but you might be better of looking at using AND instead, i.e.
=if(and(EP2,EP3),X,if(and(EP2,EP3,TP2,TP3),Y,Z)
etc

(where EP2 = "end plate two", and presuming these are Yes/No parameters.

3. He needs the brackets since he has a special character, . , in the parameter name.

Lengthy formula would be...
Roof Panel Span = Span Calc + if([3rd End Plate On.Off], 180 mm, if([2nd End Plate On.Off], 90 mm, 0 mm)) + if([2nd End Plate On.Off], 45mm, 0) + if([3rd End Plate On.Off], 45mm, 0) + if([2nd Top Plate On.Off], 45mm, 0) + if([3rd Top Plate On.Off], 45mm, 0)

4. Hi, not sure on brackets, i need to come back to resolve this, however I have another issue with a family. I'll start a new thread on this one....

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•