View Single Post
 
Old 01-12-2017, 11:41 PM
Cyberseeker Cyberseeker is offline Windows 10 Office 2010 32bit
Advanced Beginner
 
Join Date: Jun 2016
Posts: 44
Cyberseeker is on a distinguished road
Default Sum within a single Cell?

This may sound a little odd, but I would like a single cell to display two figures in the following format: + 19 + 1 Both plus (+) signs need to be displayed.

Then, in an adjacent cell I would like to sum the first cell and divide it thus: =B69/4 The answer in this hypothetical example should be "5", but no plus sign should appear in this case.

My efforts today give me a result of, "#value" Can I get it to do what I want?

Thanks for any help.
Reply With Quote