goal

Goal Seek is not working correctly for me for some reason. For example, take the three cells: A1, B1, C1. C1 = A1 + B1 A1 = 1 Now, I start Goal Seek and use the following information: Set: C1 To value: 8 By changing: B1 Instead of Goal Seek changing B1 to 7 (1 + 7 = 8), I get the...

Hello, I recorded a macro for a goal seek and goal cell and variable input I can link to excel, however if I want to change the goal value, I have to go into the macro and change it there. Tried to name the goal cell and enter that in the macro, but that doesn't work. Anyone has a solution?

Hi, was hoping someone might be able to help me come up with a formula for sales % to goal payout....for example, if they reach: <=80% pay 2.5% of actual sales 81-89% pay 3% 90-94% pay 3.5% 95-99 pay 4% >=100 pay 5% I'm not sure how I would set up a lookup table since it's a range and having...

Hey Folks: 2 questions: Multiple IF Statements Background: Calculating flowthrough, returning a score (0%, 25%, 50%, 75% or 100%) based on whether sales (F5) are positive or negative) End Goal If Cell F5 is > 100%, perform these statements...

I am new in excel. I have a question-what is the difference between goal seek feature and iteration? Regards,

Hi, I am making a balanced scorecard in excel. I have on sheet called "main", where I have a figure with different goals. To the left of each goal I have a shape which sends me to the sheet where the data for that goal is placed when clicked on. In each sheet with data, the data is filled with...

Hello all, Here at work, I need to figure out how many more PTs are needed to reach the target goal of 15%. What formula can I use in order to get the amount without figuring it out myself. Any help is greatly appreciated. Thanks! <tbody> PTs WELDS PTd % GOAL % PTs NEEDED TO REACH...

How to use Goal Seek to change the period of the loan to limit dollar amount?

Hi Where is Solver in excel 2010? I have seen videos about how to use solver (Under Data-->What-IF) but what I have under What-if is 1) Scenario 2) Goal Seek 3)Data Table. Thanks

I'm trying (and failing:laugh:) with some VBA code to make a 'Bulk Goal Seek'. My Goal Seek is as follows: Set Cell Range is G2:G1001 Value I want is 12.00% Change Cell Range is B2:B1001 So I want to Goal Seek Cell G and convert it to 12% (or closest match) by changing cell B. The other cells...

Hi, I defined a list (1,2,3,4,5,6,7,8,9,10,11,12,13) which represents Week Number for a sales goal attainment report. Based on what the user selects, it uses a formula to sum that number of weeks cumulative goal and sums that number of weeks actual sales. It's a long formula and curious if...

Here is Sheet 1. This is a student grade book. If a student has an x under a topic, that means they have achieved that goal. Test has therefore achieved 'Recognise the use of binary numbers...' etc. Here is sheet 2. When a student types their name: 'Test' in this example -> I want the...

I am trying to create a drop down selection list to a command button based from a formula. Please see below for what I have so far. Private Sub CommandButton2_Click()<o:p></o:p> For X = 1 To Selection.Rows.Count<o:p></o:p> n = Selection.Row + X - 1<o:p></o:p>...

Hello! New user here! I've been trying to figure out for a day and can't seem to find any help on any thread for this, so I decided to post a new one. Below is the sample database for my problem. The final goal is to have a cell that returns the number of times a unique brand (Column A with no...

I'm looking for a formula to help me determine the lowest set of data based on these characteristics. We have contests that we run that have certain base criteria. Here is what the criteria is for the 2 different states. For Michigan you need to be 15% above the minimum and for Ohio you need...

I have the following code, but I would like to have the Goal Seek stop once P22 reaches a minimum of 0. Is this possible? Basically I have a model with two drivers of revenue. And the Goal Seek (aka breakeven) on one of them is 0.00 if the other revenue driver is sufficient. Thus, I do not need...

I am trying to run a breakeven analysis using a Goal Seek. The Goal Seek looks at the NPV, and should put in a new price to change the NPV to 0. However, I would like for the NPV cell to retain the formula rather than change to the hard-coded number 0 every time I run it. Is there something...

Hello,i am trying to do what i thought would be a simple macro but its frustrating me!the basic macro is Range("AI136").GoalSeek Goal:=0, ChangingCell:=Range("AI347")so that goal seek will be ran to change the number in row 347 to make 136=0 the problem is i need this donein each of columns AI:CC

The title explains most of what I want to know, is there a way to create multiple filters on the same excel sheet, in the same columns without the use of tables. This would be to filter multiple sets of data to determine who is leading over others on a simple report. In this case I would need...

I think I may be having a bad day but i just can't get the right structure for a solution in my head. If I have a table that I will be adding activities to. <colgroup><col span="7"><col></colgroup><tbody> DATE Column1 ACTIVITY DURATION (minutes) Practical Pages Video NOTES 24/07/2015 6:30...