1

Excel spoji tekst i formulu i oblikuj broj

written by js | 2024-03-12

Formula

=CONCAT ( "Stupci P i Q - Stanje: " ; TEXT ( SUM (P105:P107) ; "[$$-en-US]#.##0,00") ; " ... (" ; TEXT ( SUM (Q105:Q107) ; "[$$-en-US]#.##0,00") ; ")" )

Rezultat

Stupci P i Q - Stanje: $1,234 ... ($2,345)

excel concat xexcel xconcat