Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

How do I calculate a sum in a cell as well as showing text in the same cell?

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!