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!

Paul Newcome

Yes. Try a JOIN function

 

=JOIN(text_to_join, [delimiter])

 

The delimiter is optional.