Closed Thread
Results 1 to 2 of 2

Using excel to solve a value in 2 equations

  1. #1
    Registered User
    Join Date
    02-26-2014
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    9

    Using excel to solve a value in 2 equations

    Hi.
    Can some one please help me with this problem (see attached).
    I have 2 equations to solve K, that use 4 inputs (A,B,D,H). A,B and D are known. H is unknown. How do i solve for H and K using excel? I know this can easily be solved by manually re-arranging the equation (such that H=1.667 and K=5) however this example is a simplified version of a more complicated sercies of calcs that i need to solve directly using excel (and I believe a macro). Can some one please help.
    Many thanks
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Using excel to solve a value in 2 equations

    Welcome to the Forum, unfortunately:

    This is pretty much a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    http://www.excelforum.com/excel-prog...e-a-value.html

    Thread Closed.

    If you feel this thread is significantly different to your other thread, send me a PM
    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

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using 2 equations to solve a value
    By jackleesteere in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-05-2014, 10:55 PM
  2. Solve for variables using multiple equations
    By yashgupta25 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-08-2012, 06:17 AM
  3. How to Solve System of Linear Equations (Without Solver)?
    By ExpatYankee in forum Excel General
    Replies: 2
    Last Post: 11-08-2011, 05:38 AM
  4. Replies: 2
    Last Post: 10-10-2011, 09:42 AM
  5. [SOLVED] how do I use the solver to solve polynomial equations?
    By Cameron PE in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-20-2006, 05:25 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