3 IF functions with similar condition

[Anonymous]

Hello Team,

Hope everyone is safe and healthy.

I am looking for help with IF function. I need to create a column where the information from exieting column needs to be modified. I am using the below formula. 

Risk SBU = IF(SCARs[SBU 2]="W&P Water & Pro","WATER & PRO",(IF(SCARs[SBU 2]="M&M Mobility & Man","MOBILITY & MAN",(IF(SCARs[SBU 2]="E&I Electric & Industry","ELECTRIC & INDUSTRY", "0","1","2")))))

But it gives error stating "Too many arguments were passed to the IF function. The maximum argument count for the function is 3." Can someone please help.

Thank you in advance !

Regards,

Smriti 

[Greg_Deckler · Accepted solution]

@Anonymous Try:

Risk SBU =
IF (
    'SCARs'[SBU 2] = "W&P Water & Pro",
    "WATER & PRO",
    IF (
        'SCARs'[SBU 2] = "M&M Mobility & Man",
        "MOBILITY & MAN",
        IF ( 'SCARs'[SBU 2] = "E&I Electric & Industry", "ELECTRIC & INDUSTRY", "0" )
    )
)

Also, use SWITCH instead. Way cleaner.