![]() |
#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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
H28Sailor | Excel | 6 | 01-09-2017 06:00 AM |
![]() |
shabbaranks | Excel | 17 | 05-13-2014 06:47 PM |
![]() |
iuliandonici | Excel | 1 | 04-13-2011 09:45 PM |
![]() |
iuliandonici | Excel | 4 | 04-13-2011 09:27 PM |
![]() |
Learner7 | Excel | 1 | 07-19-2010 10:06 AM |