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.
|