+ Reply to Thread
Results 1 to 3 of 3

Three Variable Equation in Excel

  1. #1
    Registered User
    Join Date
    10-08-2015
    Location
    Spruce Pine, North Carolina
    MS-Off Ver
    2013
    Posts
    1

    Exclamation Three Variable Equation in Excel

    I would like to know how to make a three variable equation in excel.
    Such as: The formula for calculating the force, Area, and Pressure of a hydraulic cylinder is P=F/A
    How would I make an excel sheet that would calculate, say, P, if I could enter in both F and A?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Three Variable Equation in Excel

    Put Force in column A, and Area in column B. Formula to calculate Pressure is

    =A1/B1

    and fill down for multiple rows of data.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    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,936

    Re: Three Variable Equation in Excel

    Hi, welcome to the forum.

    Perhaps this will get you started?
    A
    B
    C
    1
    P F A
    2
    20
    100
    5

    A2=B2/C2

    Note that if you want to swap things areound, you would need a different formula
    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)

Similar Threads

  1. Using Excel to Maximize Multi-Variable Equation
    By proehl4six in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-26-2015, 12:22 AM
  2. multi variable equation
    By KJK in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2013, 10:36 AM
  3. [SOLVED] Variable dependent equation
    By samuelabyrd in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-25-2013, 10:18 PM
  4. Variable equation help....VAT issue.
    By skyping in forum Excel General
    Replies: 5
    Last Post: 01-22-2011, 06:48 PM
  5. Variable in Sum Equation
    By james_curia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-01-2008, 09:30 AM
  6. Using Cell Values as Equation Variable
    By HodakMoment in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2007, 02:53 PM
  7. [SOLVED] Two unknown variable equation
    By John in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-10-2006, 04:55 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