Setting up math formula to solve for variable in Excel

[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

 

[dvt]

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