Setting up math formula to solve for variable in Excel

  • Thread starter Thread starter Laura G
  • Start date Start date
L

Laura G

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 said:
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
Click to expand...

Try Tools|Goal Seek.

Dave
dvt at psu dot edu
 
Back
Top