Parametric Array Formula

Parametric Array Formula

shelmsGYSXD
Advocate Advocate
540 Views
3 Replies
Message 1 of 4

Parametric Array Formula

shelmsGYSXD
Advocate
Advocate

I have a simple question, I think my brain is just fried from the long week. I am trying to do a parametric array with some holes and I just need help with my formula. Here's what you need to know, when the Length is 1' the Array should be 3, when the Length is 2' the Array should be 7, when the Length is 4' the Array should be 15, when the Length is 6' the Array should be 23, and when the Length is 8' the Array should be 31. What formula will turn out these numbers for me?

0 Likes
Accepted solutions (2)
541 Views
3 Replies
Replies (3)
Message 2 of 4

mhiserZFHXS
Advisor
Advisor
Accepted solution

(Length*4) - 1

 

Actually, you'll need to get rid of the units, so:

 

((Length/1)*4) - 1

0 Likes
Message 3 of 4

ToanDN
Consultant
Consultant
Accepted solution

(Length/3")-1

0 Likes
Message 4 of 4

shelmsGYSXD
Advocate
Advocate

That second one works perfectly, thank you!

0 Likes