+ Reply to Thread
Results 1 to 7 of 7

Finding unknown value

  1. #1
    Registered User
    Join Date
    01-24-2013
    Location
    Salem, OR
    MS-Off Ver
    Excel 2010
    Posts
    3

    Finding unknown value

    I'm having trouble trying to find an unknown value for a spreadsheet. Maybe there is some formula that can help me?

    C1=B1/A1
    C2=B2/A2
    etc...

    A5=SUM(A1:A4)
    B5=SUM(B1:B4)
    C5=SUM(C1:C4)

    I want to have C6 show how much "B" column to subtract to get the value I want (15%) in C5. Maybe C5 says 64%, but I need to know if I want C5 to equal 15%, then I need to subtract "X".

  2. #2
    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,242

    Re: Finding unknown value

    Hi Visigoth and welcome to the forum

    i would suggest you upload a sample work book, (all sensitive data removed), showing what data you are working with, a few examples of what your expected outcome is, and how you arrived at that
    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.
    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

  3. #3
    Registered User
    Join Date
    01-24-2013
    Location
    Salem, OR
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Finding unknown value

    Ok, I appreciate the advice. I've attached a workbook that is a little different than my description. In the workbook I'm trying to get F12 to equal the amount of "# of waivers" needed to be subtracted to get the total "% of waivers" down to 15%. I can manually figure it out, but if I could understand a formula that makes it automatic, it'd greatly reduce working time. My "formula knowledge" is pretty limited.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    10-25-2012
    Location
    California, USA
    MS-Off Ver
    Excel 2007
    Posts
    71

    Re: Finding unknown value

    Well one problem is that total% is not additive. You need to calculate total waivers percentage as total completions divided by total waivers, which in your cases is only 8.63%. If you did exceed your 15% mark though, this is the formula;
    Please Login or Register  to view this content.

  5. #5
    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,242

    Re: Finding unknown value

    1st, remove all the merging you have there, it will cause problems with formulas leter on.

    2nd, for D9, you cannot add the % together, you have to calc then the same way you did for all the others...
    =C9/B9 (these are the references after I removed the extra columns)
    then use swhitsel's formula

  6. #6
    Registered User
    Join Date
    01-24-2013
    Location
    Salem, OR
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Finding unknown value

    Thank you everyone!

  7. #7
    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,242

    Re: Finding unknown value

    Happy to help, and thanks for the feedback, guys

+ 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