Right now, a cell is showing the value:
10
I want it to show:
10 kg or 22 lbs
And I want that to happen in the same cell.
Also, that 10 is also a result of a calculation =B2-80
I ended up using the concat formula a bunch of times.
-
@MARKMYANSWER I think that the last edit is inappropriate as the added sentence is part of an answer of the OP.– Rubén - Volunteer Moderator - ♦Commented Jan 18, 2019 at 18:10
Add a comment
|
2 Answers
=B2-80&"kg or "&(B2-80)*2.2&" lbs"=JOIN("kg or "; B2-80; (B2-80)*2.2&" lbs")=CONCAT(B2-80&"kg or "; (B2-80)*2.2&" lbs")=CONCATENATE(B2-80; "kg or "; (B2-80)*2.2; " lbs")
Actually, I ended up using the concat formula a bunch of times. Like so:
=CONCAT(B2-80,concat("kg",concat(" or ", concat((B2-80)*2.2," lb"))))