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!
Gelöst! Gehe zur Lösung
Gelöst von ToanDN. Gehe zur Lösung
@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", " "))
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", " ")
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.