+ Reply to Thread
Results 1 to 5 of 5

Multiple values display in same cell?

  1. #1
    Registered User
    Join Date
    10-05-2011
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Multiple values display in same cell?

    Is it possible to display multiple values in the same cell? Column A - total fruit / Column B - total apples / Column C - total oranges / Column D - percentage or breakdown of apples/oranges, such as 40%- 60% or some variation... thanks

  2. #2
    Forum Expert Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,284

    Re: Multiple values display in same cell?

    Do you mean like this

    =INDEX({"0-20%","20-40%","40-60%","60-80%","80-100"},MATCH(B2/A2,{0,0.2,0.4,0.6,0.8,1}))

  3. #3
    Registered User
    Join Date
    10-05-2011
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Multiple values display in same cell?

    Not quite that. If the total was 55 with 11 apples and 44 oranges, I would want to see 20 / 80, where the 2 values add up to 100%.

  4. #4
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    Sunderland, England
    MS-Off Ver
    Excel 2007 (Home) / 2003 (Work)
    Posts
    740

    Re: Multiple values display in same cell?

    Something like:

    =TEXT(B2/A2,"0%")&"-"&TEXT(C2/A2,"0%")

    ?

  5. #5
    Registered User
    Join Date
    10-05-2011
    Location
    Chicago, USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Multiple values display in same cell?

    Yep! Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1