MULTIPLE IFs

[AKARSEVGI]

EXCHRATE2 = IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) <> "TL" ,

IF ( RELATED('SHEAD-SALHEAD'[EXCHRATE]) <= 1 ,

IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "EUR" ,RELATED('FITEM-FINITEM'[HEXCHRATE])),

IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "USD" ,(RELATED('CURRENCY'[EUR]) /RELATED('FITEM-FINITEM'[HEXCHRATE]) * RELATED('CURRENCY'[USD]))),

IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "GBP" ,(RELATED('CURRENCY'[EUR]) /RELATED('FITEM-FINITEM'[HEXCHRATE]) * RELATED('CURRENCY'[GBP]))),

IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "AUD" ,(RELATED('CURRENCY'[EUR]) /RELATED('FITEM-FINITEM'[HEXCHRATE]) * RELATED('CURRENCY'[AUD]))),

RELATED('FITEM-FINITEM'[HEXCHRATE])

,

IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "EUR" ,RELATED('SHEAD-SALHEAD'[EXCHRATE])),

IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "USD" ,(RELATED('CURRENCY'[EUR]) / RELATED('SHEAD-SALHEAD'[EXCHRATE]) * RELATED('CURRENCY'[USD]))),

IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "GBP" ,(RELATED('CURRENCY'[EUR]) / RELATED('SHEAD-SALHEAD'[EXCHRATE]) * RELATED('CURRENCY'[GBP]))),

IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "AUD" ,(RELATED('CURRENCY'[EUR]) / RELATED('SHEAD-SALHEAD'[EXCHRATE]) * RELATED('CURRENCY'[AUD]))),

RELATED('SHEAD-SALHEAD'[EXCHRATE])

)

,

RELATED('CURRENCY'[EUR])

)

Error: Too many arguments were passed to the IF function. The maximum argument count for the function is 3.

How can I fix it?

[v-rongtiep-msft · Accepted solution]

Hi @AKARSEVGI ,

Please have a try.

EXCHRATE2 = IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) <> "TL" &&RELATED('SHEAD-SALHEAD'[EXCHRATE]) <= 1 &&RELATED('SHEAD-SALHEAD'[CURRENCY]) = "EUR" ,RELATED('FITEM-FINITEM'[HEXCHRATE]), IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "USD" ,(RELATED('CURRENCY'[EUR]) /RELATED('FITEM-FINITEM'[HEXCHRATE]) * RELATED('CURRENCY'[USD])),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "GBP" ,(RELATED('CURRENCY'[EUR]) /RELATED('FITEM-FINITEM'[HEXCHRATE]) * RELATED('CURRENCY'[GBP])),
 
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "AUD" ,(RELATED('CURRENCY'[EUR]) /RELATED('FITEM-FINITEM'[HEXCHRATE]) * RELATED('CURRENCY'[AUD])),
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "EUR" ,RELATED('SHEAD-SALHEAD'[EXCHRATE]),
 
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "USD" ,(RELATED('CURRENCY'[EUR]) / RELATED('SHEAD-SALHEAD'[EXCHRATE]) * RELATED('CURRENCY'[USD])),
 
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "GBP" ,(RELATED('CURRENCY'[EUR]) / RELATED('SHEAD-SALHEAD'[EXCHRATE]) * RELATED('CURRENCY'[GBP])),
 
IF(RELATED('SHEAD-SALHEAD'[CURRENCY]) = "AUD" ,(RELATED('CURRENCY'[EUR]) / RELATED('SHEAD-SALHEAD'[EXCHRATE]) * RELATED('CURRENCY'[AUD])),
 
RELATED('SHEAD-SALHEAD'[EXCHRATE])
,
RELATED('CURRENCY'[EUR])
))))))))

Please use the correct if statement.

I have created a simple sample, please refer to it to see if it helps you.

Then create a column.

Column =
IF (
    ( 'SHEAD-SALHEAD'[EXCHRATE] ) <= 20
        && ( 'SHEAD-SALHEAD'[CURRENCY] ) = "EUR",
    "1",
    IF (
        'SHEAD-SALHEAD'[CURRENCY] = "AUD"
            && 'SHEAD-SALHEAD'[EXCHRATE] >= 18,
        "aUD ",
        IF (
            'SHEAD-SALHEAD'[CURRENCY] = "GBP"
                && 'SHEAD-SALHEAD'[EXCHRATE] <= 14,
            "good gbp",
            "unsatisfy"
        )
    )
)

The meaning of the formula: 

[CURRENCY] column is  equal to EUR and the value [EXCHRATE] is less than 20, then output 1, if  [CURRENCY] column is  equal to AUD and the value [EXCHRATE] is less than 18,then output aUD, if  [CURRENCY] column is  equal to GBP and the value [EXCHRATE] is less than 14,then output good gbp, All other results that do not satisfy the above conditions are output “Unsatisfy".

If I have misunderstood your meaning, please provide some simple sample data without privacy information and your desired output.

How to Get Your Question Answered Quickly 

 Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.