Multiple if statements in one calc column

[Anonymous]

Hi All,

I am tring to execute a multiple if statement in one calc column but it didnt work,

So I am tring to implement a switch statement but niether wont work.

SupplierHecPollNL =  IF(Tankingen[Land]="Netherlands" && Tankingen[Leverancier]="HecPoll" ;"Papendrecht_HecPoll";Tankingen[Leverancier]);

(IF(Tankingen[Land] = "Netherlands" && Tankingen[Leverancier] = "HecPoll"; "Papendrecht_HecPoll";Tankingen[Leverancier])

Can somenone help please?

Regards,

Ezz

[amitchandak]

@Anonymous , you first if

IF(Tankingen[Land]="Netherlands" && Tankingen[Leverancier]="HecPoll" ;"Papendrecht_HecPoll";Tankingen[Leverancier])

HAs ended here. after that is just repeat.

If you need to loop if

IF(Tankingen[Land]="Netherlands" && Tankingen[Leverancier]="HecPoll" ;<If here>;<If here>)

Or use Switch True

Switch(True(),

<condition>, <action>,

<condition>, <action>,

<condition>, <action>,

<else action>

)

[nandukrishnavs]

@Anonymous 

Try this

SupplierHecPollNL =
IF (
    Tankingen[Land] = "Netherlands"
        && Tankingen[Leverancier] = "HecPoll";
    "Papendrecht_HecPoll";
    IF (
        Tankingen[Land] = "Netherlands"
            && Tankingen[Leverancier] = "Replace with another value";
        "Papendrecht_Replace with another value";
        Tankingen[Leverancier]
    )
)

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[az38 · Accepted solution]

Hi @Anonymous 

you gave completely the same sentence written twice.

use only this

SupplierHecPollNL =  IF(Tankingen[Land]="Netherlands" && Tankingen[Leverancier]="HecPoll" ;"Papendrecht_HecPoll";Tankingen[Leverancier])

or use SWITCH()

SupplierHecPollNL =  
SWITCH(TRUE();
Tankingen[Land]="Netherlands" && Tankingen[Leverancier]="HecPoll" ; "Papendrecht_HecPoll";
Tankingen[Land]="Other" && Tankingen[Leverancier]="Other" ; "Otehr Value";
Tankingen[Leverancier]
)