How can I combinate two Formulas

[#1]

Hello together,

i have a Problem with two Formulas, how can I combinate the two following Formulas:

1.

if (Währung <> 'EUR', EffektwertSumme*Kurs)

2.

SUM(IF(Kreditorabkürzung = '3', 0, [EffektivwertSumme]))

Do you have any solution, how I can combinate this to formulas.

Thank you.

Greets

Nikolaus80

[RedSky001 · Accepted solution]

Depends what outcome you want, you've not provided enough informaton.  However as an exmaple you could do the following:

SUM(IF(Kreditorabkürzung = '3' ,0, if(Währung <> 'EUR' ,EffektwertSumme*Kurs,EffektwertSumme)))