Ask Your Question

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

asked 2017-02-09 06:00:12 +0200

appreciatethehelp gravatar image

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!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-02-09 07:19:36.969892

2 Answers

Sort by » oldest newest most voted

answered 2017-02-09 06:34:35 +0200

robleyd gravatar image

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

edit flag offensive delete link more

answered 2017-02-09 06:28:55 +0200

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).

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-02-09 06:00:12 +0200

Seen: 106 times

Last updated: Feb 09 '17