Solved

Excel 2007 Using Goal Seek To Determine New Rate

Posted on 2010-11-17
2
444 Views
Last Modified: 2012-05-10
Hello,

Please see the attached example.  I apologize for how the data is located but I tried to keep everything on the same rows as the actual spreadsheet.

I would like to know if goal seek can be used with a payment formula in order to take the guess work on adjusting a rate to equal a particular amount.  As it stands, in order to make the calculation result equal the amount required, we are having to enter multiple random rate percentages.  Im hoping someone will have suggestions on how to take the guess work out and thought goal seek might be a solution but I can seem to wrap my head around it with this existing format.

What Im hoping to obtain is some instructions on how to use goal seek in the attached file so that if we want the amount in E74 to equal $1,880.00 goal seek will automatically change the rate amount in cell E64 to 4.55%.

Thanks!
0
Comment
Question by:Escanaba
2 Comments
 
LVL 1

Author Comment

by:Escanaba
ID: 34155763
0
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 34155902
Yes, Goal Seek will do this readily.

1) Select Data / Data Tools / What If / Goal Seek from the ribbon

2) In Goal Seek, set e74 to value 1880 by changing cell e64

3) Result is 4.55%
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We are taking giant steps in technological advances in the field of wireless telephony. At just 10 years since the advent of smartphones, it is crucial to examine the benefits and disadvantages that have been report to us.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now