+ Reply to Thread
Results 1 to 3 of 3

help solving percentage formula

  1. #1
    Registered User
    Join Date
    04-10-2012
    Location
    california
    MS-Off Ver
    Excel 2003
    Posts
    1

    help solving percentage formula

    ok here is my problem, each company is authorized certain slots for schools now i'm asking for help i need one FORMULA they will calculate the persentage from what they have on HAND to what their authorized,please help,i also added my chart so you can have a better idea with what i need help with.thanks

    V/R

    David549
    Attached Files Attached Files
    Last edited by david549; 04-11-2012 at 10:10 AM. Reason: NEW INFO

  2. #2
    Registered User
    Join Date
    04-10-2012
    Location
    Argentina
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: help solving percentage formula

    I'm not sure I'm getting it... a percentage is just a division

    % = ON HAND / AUTHORIZED

    And go to CELL FORMAT > NUMBER > PERCENTAGE to make the cell have the corresponding formatting.

    Or was it something else? Please explain better if so.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,123

    Re: help solving percentage formula

    looking at your file....just a few observations/suggestions

    1. the "1" you have in B4 is actually text, not a value
    2. your formula in H4 starts off by testing B4+C4+D4+E4+F4 with the contents of G4...G4 is the sum of those values, so (if you enter values instead of text), it will always be "true" and return a ""
    3. in H4, try using =(M4-K4)/M4 and format it as % (which it already is)
    4. if you need to return a blank if any of the cells has no data, use =iferror((M4-K4)/M4,"")

    Let me know if this is what you wanted?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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