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!
Solved! Go to Solution.
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!
Solved! Go to Solution.
Solved by ToanDN. Go to 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", " "))
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.