I am trying to get a formula to generate a room Number and can get it working using numbers for my room types but I would like it to work with text eg replace the “1” with Room, “2” with Lift, “1” with Stairwell but I cannot get it to work. Is this possible or am I just not doing something right.

If [RoomType]="1" Then
RESULT ="R[FloorLevel].[Room_ID]"
ElseIf [RoomType]="2" Then
RESULT = "L[FloorLevel].[Room_ID]"
ElseIf [RoomType]="3"Then
RESULT = "S[FloorLevel].[Room_ID]"
Else
RESULT ="SD[FloorLevel].[Room_ID]"
End If