It seemed to be an easy work, but I can’t get it done:

Given:

I4: 0.32

E4: 12

=Round(I42;2) & “/pc // ” & Round(I42*E4;2) & “/unit”

gives the result string “0.64 /pc // 7.68 /unit”

I want to format the result into
“€ 0.64 /pc // € 7.68 /unit”

I tried to use TEXT but in any worksheet TEXT does not work!
Simple =TEXT(I4;”00″) gives #NAME

Same as =TEXT(I4;”€ #.##0,00″) which should give “€ 0,32”.

So =TEXT(Round(I42;2);”€ #.##0,00 /pc”) & ” // ” & TEXT(Round(I42*E4;2); & “”€ #.##0,00 / unit”) does not work and gives #VALUE.

Thanks your help.