Nested IFs cause unexpected end of expression error

[eumanzorLAARC1]

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

[RDAOU]

@eumanzorLAARC1 

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

[barthbradley]

You can't reference a Text Parameter.  You could reference an integer. For instance =If(Integer Parameter=1, "My Text", "My Other Text") 

[eumanzorLAARC1]

Thank you guys, I think I can find a work around from there.