Revit Formula Query

Revit Formula Query

broden.l
Participant Participant
1,031 Views
8 Replies
Message 1 of 9

Revit Formula Query

broden.l
Participant
Participant

I'm wondering if anyone can help with a formula I'm trying to create.

 

I have 2 options for height 870 & 830. the formula I've entered doesn't work. does anyone have any ideas on what I'm doing wrong?

0 Likes
Accepted solutions (1)
1,032 Views
8 Replies
Replies (8)
Message 2 of 9

barthbradley
Consultant
Consultant

remove 834.png

0 Likes
Message 3 of 9

broden.l
Participant
Participant

Hey Barthbradley,

I've done that but it's come up with this.

 

Do I not need this figure though when the L Panel Offset doesn't equal 150mm

 

0 Likes
Message 4 of 9

barthbradley
Consultant
Consultant

You need to add more Parentheses to end of Formula))

0 Likes
Message 5 of 9

broden.l
Participant
Participant

Revit has accepted the formula but now the panel height isn't high enough when the height = 870 & L Panel offset is 0,

which is the 834 I deleted.

0 Likes
Message 6 of 9

MetalFingerz
Advocate
Advocate
Accepted solution

Hi @broden.l ,

 

Can you try this :

if(Height = 870,
	if(L Panel Floor Offset = 150, 684, 834),
	if(L Panel Floor Offset = 150, 644, 794)
)
0 Likes
Message 7 of 9

barthbradley
Consultant
Consultant

Post the family (rfa) here.  

0 Likes
Message 8 of 9

broden.l
Participant
Participant

Please find attached.

0 Likes
Message 9 of 9

broden.l
Participant
Participant

Thanks, MetalFingerz, that formula works perfectly. Much appreciated!!