Just as the title suggests.
For example I want cell C1 to display the total of cells A1 ad B1, (=A1+B1) as well as some text unrelated to the calculation as well.
How would the formula look?
Each time I enter text anywhere in the cell (C1) it just screws up the calculation. I have tried putting it before and after the calculation, have tried using quotation marks too.
Can this be done, and if so, how?
Many thanks!
You may enter formula like this:
="This is sum: " & A1+B1 & " dollars"
Or you may use cell’s (style’s) number format to add text beside number, like this:
"Sum: " # ##0,00 " cups"
The latter allows you to continue using the cell in further calculations (it only affects appearance; the inner cell contents is still the number).
Use the ampersand to concatenate text and formula result; for example, if A1 is 16 and A2 is 12 ="Foobar "& A1+A2 will display Foobar 28