Announcements

Announcement: We’re aware of an issue affecting starting a new topic from category pages and creating new blog posts. New topics can still be started directly from the relevant board. Learn more here.

Revit Formula Query

Revit Formula Query

broden.l
Participant Participant
1,749 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,750 Views
8 Replies
Replies (8)
Message 2 of 9

barthbradley
Consultant
Consultant

remove 834.pngremove 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!!