Hi Zigarlos,

Something like this should do what you're looking for:

=FIXED(A1,0) & " half-time leads in " & FIXED(A2, 0) & " games (" &
FIXED(A3*100, 2) & "%) has resulted in 1 win."

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

Zigarlos wrote:
I need a sentence saying: 2 half-time leads in 4 games (66,67%) has
resulted in 1 win.

I've got these cells: (A1=2) (A2=4) (A3=66,67%) and I tried this:

=concatenate("";a1;" half-time leads in ";a2;" games (";a3;") has
resulted in 1 win."). But the result is: 2 half-time leads in 4 games
(0,66666666666666667) etc

Then I tried this:

=concatenate("";a1;" half-time leads in ";a2;" games (";a3*100;"%) has
resulted in 1 win.") The result: 2 half-time leads in 4 games
(66,666666666666667%) etc

How can I return only 2 digits, so the result is 66,67% ??