![]() |
|
#1
|
|||
|
|||
|
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. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Combining several cells data into one single cell
|
H28Sailor | Excel | 6 | 01-09-2017 06:00 AM |
Sum values within a single cell
|
shabbaranks | Excel | 17 | 05-13-2014 06:47 PM |
How to count multiple values in a single cell, except zero?
|
iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |
Sum & difference between multiple values in a single cell
|
iuliandonici | Excel | 4 | 04-13-2011 09:27 PM |
How can I write the following (whole) formula in a single cell?
|
Learner7 | Excel | 1 | 07-19-2010 10:06 AM |