Setting up math formula to solve for variable in Excel

Discussion in 'Microsoft Excel Worksheet Functions' started by Laura G, Jul 10, 2003.

  1. Laura G

    Laura G Guest

    Is there a way to set up a formula in Excel to solve for M
    in the following formula? The variable "A" can be
    different but is a "known" value.

    P(M) + P(M-.005) + P(M-.010) + P(M-.015) = A
     
    Laura G, Jul 10, 2003
    #1
    1. Advertisements

  2. Laura G

    dvt Guest

    Laura G wrote:
    > Is there a way to set up a formula in Excel to solve for M
    > in the following formula? The variable "A" can be
    > different but is a "known" value.
    >
    > P(M) + P(M-.005) + P(M-.010) + P(M-.015) = A


    Try Tools|Goal Seek.

    Dave
    dvt at psu dot edu
     
    dvt, Jul 10, 2003
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Why can't Solver solve my one-variable query, when Goal Seek can?

    Guest, Jul 31, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    339
    Guest
    Aug 8, 2004
  2. Guest

    solver can not solve polynomial eq. where one variable is five di.

    Guest, Nov 1, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    245
    Tushar Mehta
    Nov 3, 2004
  3. auto
    Replies:
    8
    Views:
    312
  4. Guest

    Question on setting up excell to solve a math problem

    Guest, Oct 27, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    169
    Dana DeLouis
    Oct 30, 2006
  5. Guest

    Excel math formula

    Guest, Oct 30, 2006, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    117
    Gord Dibben
    Oct 30, 2006
Loading...

Share This Page