Concatenate Formula

[Manos]

Dear all,
Does anyone no if in a field of a concatenate formula i
can make a sum function?
eg: in the first text i add the word Euro
and in the second field i want to add a sum of two
differenct cells

there is anyway i can do this work?

Regards
Manos

 

[Frank Kabel]

Hi Manos
one way:
="Euro " & TEXT(A1+B1,"0,00")
but wouldn't a cell format better suited for your need. So just simply
add your cells and format the resulting cell as currency (goto
'Format - Cells')

HTH
Frank

 

[Paul]

Dear all,
Does anyone no if in a field of a concatenate formula i
can make a sum function?
eg: in the first text i add the word Euro
and in the second field i want to add a sum of two
differenct cells

there is anyway i can do this work?

Regards
Manos

Don't use CONCATENATE here. Instead, try something such as
="Euro"&(A1+B1)