If or formula not working

[Usamah22]

I have the below if formula but it is giving an error about a malformed if statement. can't see anything wrong with it?

if [E Flag]="Yes" then "E Customer"
else if [M Portal]="Yes" then "M Customer"
else if [A Flag]="Yes" then "A Customer"
else if [C Customer]="Yes" then "C Customer"
else if ([Current Price]="d11" or [Current Price]="Urgent") then "D"
else "Other" endif

[Qiu]

@Usamah22 

Missing 4 endif.😁

[Kenda · Accepted solution]

Hey there @Usamah22 

Try getting rid of the space between all of your "else if" bits (i.e. change them all to elseif).

[Emil_Kos]

Hi @Usamah22,

I believe you need to do small amendment:

if [E Flag]="Yes" then "E Customer"
elseif [M Portal]="Yes" then "M Customer"
elseif [A Flag]="Yes" then "A Customer"
elseif [C Customer]="Yes" then "C Customer"
elseif ([Current Price]="d11" or [Current Price]="Urgent") then "D"
else "Other" endif

I have aded a workflow for you as well.

Please mark my post as a solution if it was helpful!