If or formula not working

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

Developer Tools

Accepted answers

Kenda

Hey there @Usamah22

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

All comments

Missing 4 endif.😁

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!

Elseif.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703