Add formula and string in cell, libre calc 2017

2
votes

I would like to have a cell that has a formula in it (like =SUM(A1:A5)) and some text after the formula, with the desired effect of something like: 50 apples

What I have tried =SUM(B:B), apples

1
libreoffice-calc

1 Answers

1
votes

Just use the CONCATENATE() function:

=CONCATENATE(SUM(B:B); " apples")

Another solution would be to define a custom number format.