+ Reply to Thread
Results 1 to 7 of 7

Displaying both Value and (Percentage) in same cell?

  1. #1
    Registered User
    Join Date
    02-10-2016
    Location
    USA
    MS-Off Ver
    2013
    Posts
    65

    Displaying both Value and (Percentage) in same cell?

    Hi all,

    I have a simple worksheet here that counts the number of occurrences in several groups. smokingstatus.xlsx

    I would like to have each cell to contain the % of occurrences in that column (percent of total, vertically).

    How can I accomplish both values in the same cell, example:

    38 (32.2)
    35 (26.7)
    45 (38.1)
    118 (100.0)

    Thank you all,
    AW

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Displaying both Value and (Percentage) in same cell?

    Where are you getting the values in the ( )?

    Data Range
    A
    B
    C
    D
    E
    F
    4
    Current
    Former
    Never
    Total
    5
    Site Name
    ACQC
    38
    10
    2
    50
    6
    BOOM
    35
    9
    6
    50
    7
    GMHC
    45
    3
    2
    50
    8
    Total
    118
    22
    10
    150
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,901

    Re: Displaying both Value and (Percentage) in same cell?

    You can' do that with a formula because, for example, the 32.2% depends in the 38 which would be in the same cell. You can have a value or a formula in a cell, not both.

    Edit: Unless, as suggested by #2, the 38 is coming from elsewhere and not typed in directly.
    Ben Van Johnson

  4. #4
    Registered User
    Join Date
    02-10-2016
    Location
    USA
    MS-Off Ver
    2013
    Posts
    65

    Re: Displaying both Value and (Percentage) in same cell?

    The values are being derived from an SPSS output (which I have copied into Excel).

    I know that SPSS can output the percentage in an adjacent cell, but for formatting purposes I was curious if I could just to this in Excel. Is this not possible because the values are 'manual' (copied) instead of calculated?

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Displaying both Value and (Percentage) in same cell?

    Quote Originally Posted by Tony Valko View Post
    Where are you getting the values in the ( )?
    Nevermind, I figured it out!

    38 is what % of 118.

  6. #6
    Forum Expert Josť Augusto's Avatar
    Join Date
    10-29-2014
    Location
    Portugal
    MS-Off Ver
    2013-2016
    Posts
    3,329

    Re: Displaying both Value and (Percentage) in same cell?

    Hi
    Try to use a new column. It's better
    See the filesmokingstatus.xlsx
    Format as (0%)

  7. #7
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Displaying both Value and (Percentage) in same cell?

    Quote Originally Posted by arwebb0264 View Post
    Is this not possible because the values are 'manual' (copied) instead of calculated?
    If you put the % in a different cell like this:

    Data Range
    A
    B
    C
    D
    E
    F
    G
    4
    Current
    %
    Former
    Never
    Total
    5
    Site Name
    ACQC
    38
    32.2%
    10
    2
    50
    6
    BOOM
    35
    29.7%
    9
    6
    50
    7
    GMHC
    45
    38.1%
    3
    2
    50
    8
    Total
    118
    100.0%
    22
    10
    150


    This formula entered in D5:

    =C5/C$8

    Format as Percentage, 1 decimal place

    Copy down.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Pivot table displaying value as percentage of another value
    By scanale42 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-24-2013, 07:49 AM
  2. [SOLVED] Chart not displaying correct percentage
    By avidcat in forum Excel General
    Replies: 2
    Last Post: 04-22-2012, 12:24 PM
  3. Displaying actual values on a percentage bar graph
    By BFlick11 in forum Excel General
    Replies: 9
    Last Post: 07-21-2011, 08:39 AM
  4. Replies: 4
    Last Post: 06-09-2010, 09:31 AM
  5. Displaying a percentage
    By Timeferret in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 08-14-2006, 03:47 PM
  6. Displaying percentage in ranges in pivot table
    By pamarty in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-10-2006, 05:00 PM
  7. Pivot Table (displaying data as a percentage)
    By PJS in forum Excel General
    Replies: 2
    Last Post: 04-11-2006, 09:10 PM
  8. Replies: 2
    Last Post: 02-01-2006, 12:50 PM

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