Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
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.
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.
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.
added 8 characters in body; edited tags; edited title
