+ Reply to Thread
Results 1 to 5 of 5

Complex Mathematical Equation

  1. #1
    Registered User
    Join Date
    05-18-2011
    Location
    North Carolina
    MS-Off Ver
    Excel 2003
    Posts
    29

    Complex Mathematical Equation

    This is probably going to be WAY to complicated to be done but I figured I would post it and give it a shot. There's people on here that know a lot more about Excel than I do and who are always willing to help.

    I'm trying to get Excel to compute a mathematical equation referencing several cells and using the answers to part of the equation to produce the final answer in a cell. I've layed out the equation below: (When I say Cell1 for instance, I want Excel to reference the number in the specified cell)

    Cell1 * Cell2 = A
    Cell3 - A = B
    Cell4 * Cell2 = C
    Cell5 - C = D
    D - B = E
    E * Cell6 = F (F being the final answer I want displayed)

    Is it possible to do all these steps in one formula? Any recommendations?

    Thx!
    Last edited by wvpersephone13; 02-15-2012 at 09:54 AM. Reason: Solved

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Complex Mathematical Equation

    Assuming cell1-cell6 = references A1-F1

    =((E1-(D1*B1))-(C1-(A1*B1)))*F1

    I think.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,082

    Re: Complex Mathematical Equation

    Isn't this simply...

    ((Cell5 - Cell4 * Cell2) - (Cell3 - Cell1 * Cell2)) * Cell6
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,082

    Re: Complex Mathematical Equation

    You can get rid of some of the brackets

    =((E1-D1*B1)-(C1-A1*B1))*F1

  5. #5
    Registered User
    Join Date
    05-18-2011
    Location
    North Carolina
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: Complex Mathematical Equation

    This is great! It looks like both of those formulas work. Thanks so much!

+ 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