Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Revit formula with multiple yes/no conditions - How to write

2 REPLIES 2
SOLVED
Reply
Message 1 of 3
ChandlerH
178 Views, 2 Replies

Revit formula with multiple yes/no conditions - How to write

ChandlerH
Observer
Observer

Hello! 

 

  I am working on a door schedule and trying to write the right formula in order for a yes/no parameter to autofill a formula parameter and indicate the fire rating of a particular door. 

 

If '20 Min' is checked, then the fire rating column should read '20 MIN'

If '90 Min' is checked, then the fire rating column should read '90 MIN'

If neither is checked, the fire rating column should remain empty. 

 

Can anyone help with formatting the formula correctly? Thanks in advance! 

 

 

0 Likes

Revit formula with multiple yes/no conditions - How to write

Hello! 

 

  I am working on a door schedule and trying to write the right formula in order for a yes/no parameter to autofill a formula parameter and indicate the fire rating of a particular door. 

 

If '20 Min' is checked, then the fire rating column should read '20 MIN'

If '90 Min' is checked, then the fire rating column should read '90 MIN'

If neither is checked, the fire rating column should remain empty. 

 

Can anyone help with formatting the formula correctly? Thanks in advance! 

 

 

2 REPLIES 2
Message 2 of 3
ToanDN
in reply to: ChandlerH

ToanDN
Consultant
Consultant
Accepted solution

@ChandlerH wrote:

 

If '20 Min' is checked, then the fire rating column should read '20 MIN'

If '90 Min' is checked, then the fire rating column should read '90 MIN'

If neither is checked, the fire rating column should remain empty. 

 

 


IF (20 Min, "20 MIN", IF (90 Min, "90 MIN", " "))


@ChandlerH wrote:

 

If '20 Min' is checked, then the fire rating column should read '20 MIN'

If '90 Min' is checked, then the fire rating column should read '90 MIN'

If neither is checked, the fire rating column should remain empty. 

 

 


IF (20 Min, "20 MIN", IF (90 Min, "90 MIN", " "))

Message 3 of 3
ToanDN
in reply to: ChandlerH

ToanDN
Consultant
Consultant

Actually, I would reverse the formula so that 90 min. takes priority, in case both values are checked, the text will say 90 instead of 20.

 

IF (90 Min, "90 MIN", IF (20 Min, "20 MIN", " ")

Actually, I would reverse the formula so that 90 min. takes priority, in case both values are checked, the text will say 90 instead of 20.

 

IF (90 Min, "90 MIN", IF (20 Min, "20 MIN", " ")

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report