PC Review


Reply
Thread Tools Rate Thread

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
 
Reply With Quote
 
 
 
 
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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 Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
changing math operations for math operations with = sign filo666 Microsoft Excel Programming 3 3rd Mar 2008 02:35 PM
Question on setting up excell to solve a math problem =?Utf-8?B?ZnJhbmsgYw==?= Microsoft Excel Worksheet Functions 3 30th Oct 2006 04:30 AM
How Math.Cos & Math.Sin is implemented? Morgan Cheng Microsoft C# .NET 13 17th Oct 2006 04:03 AM
excel math forumla? (simple math problem inside for math people!) Jason Microsoft Excel Discussion 3 16th Feb 2006 11:54 AM
Opterons used to solve RSA math problem EdG Processors 3 14th Nov 2005 11:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:23 AM.