+ Reply to Thread
Results 1 to 3 of 3

Excel formula to solve a mathematical issue

  1. #1
    Registered User
    Join Date
    05-18-2010
    Location
    Europe
    MS-Off Ver
    Excel 2010
    Posts
    54

    Excel formula to solve a mathematical issue

    Hi guys,

    I have a mathematical issue I would like to solve using Excel.
    The column A shows 3 values (e.g. 1, 2 and 3 but countless combinations are possible). The column B shows 3 unknown quantities (x, y and z). I need to find the value of x, y and z in order to get contemporaneously positive values in C1, C2 and C3. Is there a way to create an excel formula which can help me with that?

    Please check the attachment to get more info.

    Thanks in advance for your help!
    Attached Images Attached Images

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Excel formula to solve a mathematical issue

    Integer or real solutions?

    What's the purpose?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    12-29-2010
    Location
    Europe, CET
    MS-Off Ver
    Excel 2004, Excel 2003, Excel 2007
    Posts
    15

    Re: Excel formula to solve a mathematical issue

    Are you trying to find a particular solution to those inequalities? You can define the right-hand side values (greater than zero) and search for a solution using Solver. For some values of (a,b,c) there will be a solution, for others there is no solution. Is this school homework or something? :-)
    http://excelblog.optkontek.com - notes on excel
    Follow @nerdpub on twitter!

+ 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