=CONCAT("https://api.paylibo.com/paylibo/generator/czech/image?compress=false";IF(B11<>"";CONCAT("&size=";B11);"&size=440");IF(B1<>"";CONCAT("&accountPrefix=";B1);"");IF(B2<>"";CONCAT("&accountNumber=";B2);"");IF(B3<>"";CONCAT("&bankCode=";B3);"");IF(B4<>"";CONCAT("&amount=";B4);"");IF(B5<>"";CONCAT("¤cy=";B5);"¤cy=CZK");IF(B6<>"";CONCAT("&vs=";B6);"");IF(B7<>"";CONCAT("&ks=";B7);"");IF(B8<>"";CONCAT("&ss=";B8);"");IF(B9<>"";CONCAT("&message=";ENCODEURL(B9));"");IF(B10<>"";CONCAT("&date=";B10);""))
Kopírovat