[Solved] Text with Formula in same cell

[Bill1426]

I am looking to add text to a calculation in the same cell...

Ex. This is the final number: (this is where the total of the calculation would be)

Is this possible ??

[Zizi64]

I am looking to add text to a calculation in the same cell...

Try this:
=(A1*B1)&"Ex"

[Bill1426]

That works if the calculation is before the text... I need it after.

[Zizi64]

="Ex"&(A1*B1)

it works for me too (on Go-OO based OxygenOffice3.2.1 on WindowsXPprof.SP3)

[Bill1426]

I keep getting the #Value error..

="Total Calories (Max 1379):"&(B271:B279)

[Zizi64]

Missing function name. SUM or other...

="Total Calories (Max 1379):"&(SUM(B271:B279))

[Bill1426]

Perfect... Thank you so much...

[Bill1426]

Thanks, but to complicated... Zizi64's answer worked perfectly...

[xroox]

I got an issue using ZiZi's method.

I was dividing numbers, and now I can't control the number of decimal places it shows... I have about 10 decimal places now and it won't fit into my cell!

[Bill1426]

Just extent the cell width...

[acknak]

Use the TEXT function to display a value according to a given format; for example, format "0" produces a number with no decimal digits.

="Total Calories (Max 1379):"&TEXT(SUM(B271:B279);"0")

[suren]

Try CONCATENATE(text1, text2) i.e. CONCATENATE("The total sum is: ",ROUND(SUM(G2:G20),2))
text1 = "The total sum is: "
text2 = ROUND(SUM(G2:G20),2)
Round(number,2) - restricts the answer to 2 decimal places