Hello i have a issue in terms of logic:

a.JPG

I have these fields that i want to concatenate in a string
Each one depends on each other for instance "VIP O2 MET EXAM - "

Examples:
If it is VIP then "VIP - " but if it is VIP and EXAM then "VIP EXAM - "
If it is O2 then "O2 - " but if it is also Metropolis then " O2 Metropolis - "
If it is none " - "

I've been going around and around with this and my head already hurts :S Can someone help me with this logic? Or an alternative?

The function is like the following
SE(B27="YES";"VIP"&SE(B28="No";C38;" ");SE(B27="No";"";" "))&SE(B28="YES";"O2"&SE(B29="No";C38;" ");SE(B28="No";" ";" "))&SE(B29="YES";"MET"&SE(B30="No";C38;" ");SE(B29="No";"";))&SE(B30="YES";"EXAM"&C38;SE(B30="No";"";" "))
I would appreciate the help a lot if you could help

Cheers.