Can I join the results from formulas in 2 differing cells?
Dave-Cisco
✭✭
Hit a brick wall, but I'll try to explain as best I can.
Cell1 has a formula for a NUMERICAL sum for a row across [Column A] + [Column B]
Cell2 has a formula to return TEXT based on value of a single cell in [Column C]
My goal is to have a single cell to display contents of Cell1 and Cell2.
I think I can join them, but can't wrap my formula skills around it.
Any help or direction is appreciated!
Comments
-
Yes. Try a JOIN function
=JOIN(text_to_join, [delimiter])
The delimiter is optional.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives