# Setting up math formula to solve for variable in Excel

Laura G
Guest
Posts: n/a

 10th Jul 2003
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
Guest
Posts: n/a

 10th Jul 2003
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

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post filo666 Microsoft Excel Programming 3 3rd Mar 2008 02:35 PM =?Utf-8?B?ZnJhbmsgYw==?= Microsoft Excel Worksheet Functions 3 30th Oct 2006 04:30 AM Morgan Cheng Microsoft C# .NET 13 17th Oct 2006 04:03 AM Jason Microsoft Excel Discussion 3 16th Feb 2006 11:54 AM EdG Processors 3 14th Nov 2005 11:33 PM

Features