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

[ChandlerH]

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! 

[ToanDN · 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", " "))

[ToanDN]

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", " ")