+ Reply to Thread
Results 1 to 2 of 2

Total value divide from number to percentage?

Hybrid View

  1. #1
    Registered User
    Join Date
    03-01-2010
    Location
    San Diego
    MS-Off Ver
    Excel 2007
    Posts
    27

    Total value divide from number to percentage?

    PHP Code: 
    INTERNAL TOTALS    10    0.0185%        
                    
    Code 85 (MSA)    8    0.0148%        OVERALL TOTAL 53,966
                    
    Inbound Scan    1            
                    
    Outbound Failure    1 
    ^^ that is an example.


    Pretty much, I enter the totals for each row. Then I enter the overall total (53,966). I want it to calculate the percentage value in the next column.

    EX:
    For internal totals, I enter: 10. Then enter overall total of 53,966 giving me a 0.0185% answer.

    10/53,966*100 = 0.0185%

    Thank you!
    Last edited by yakabod; 02-27-2012 at 01:49 PM. Reason: problem solved.

  2. #2
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Total value divide from number to percentage?

    you can do this in a formula by referencing the other cells:

    =A1/B2

    then formating as a %, see the example attached
    Attached Files Attached Files
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

+ 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