How to use multiple checks in "IF" formula?

Question

Google Sheets

You need to use several IF checks and, depending on the currency in the cell, substitute your own formula. Now the formula looks like this

=ЕСЛИ(D4="UAH";1;ЕСЛИ(D4="USD";ПОДСТАВИТЬ(IMPORTXML("https://api.privatbank.ua/p24api/exchange_rates?date="&ТЕКСТ(A4;"DD.MM.YYYY");"//exchangerates/exchangerate[@currency='USD']/@saleRateNB");".";",";));ЕСЛИ(D4="EUR";ПОДСТАВИТЬ(IMPORTXML("https://api.privatbank.ua/p24api/exchange_rates?date="&ТЕКСТ(A4;"DD.MM.YYYY");"//exchangerates/exchangerate[@currency='EUR']/@saleRateNB");".";",";)))

But this error is given https://tppr.me/UwGWu
Moreover, if you use 2, not 3 IF, then everything works.

=ЕСЛИ(D3="UAH";1;ЕСЛИ(D3="USD";ПОДСТАВИТЬ(IMPORTXML("https://api.privatbank.ua/p24api/exchange_rates?date="&ТЕКСТ(A3;"DD.MM.YYYY");"//exchangerates/exchangerate[@currency='USD']/@saleRateNB");".";",";)))

Maybe someone can tell me what the problem is

Answer 1

Here is an extra bracket, it turns out the wrong number of arguments. The picture shows the correct solution.