I'm trying to create a conditional if statement in an area schedule for occupancy load calculations, but I'm not sure if my syntax is correct or if the statement is flawed, because I keep getting an "Unexpected end of expression" error message, please help.
IF (Name="BUSINESS", Area/100, IF (Name = "MECHANICAL", Area/300, IF (Name = "MERCANTILE", Area/30, IF (Name = "STORAGE", Area/300, IF (Name = "KITCHEN", Area/200, 0))))
based on the number of nested IFs you are missing a bracket at the end.
However it wont work even if you get the closing brackets right, Reason: you are using TEXT as a condition in a formula that is not possible in Revit atm...it can be used only as a result
YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION
You can't reference a Text Parameter. You could reference an integer. For instance =If(Integer Parameter=1, "My Text", "My Other Text")
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.