goal

  1. D

    Calculate Factors to Achieve Goal

    I'm having a challenge in resolving an algebraic problem using excel and would really appreciate some help. Scenario: Call center has goal of answering 80% of calls offered within X time Sum of calls currently answered at goal is 369 Forecast remaining calls in day is 1854 Objective: How...
  2. N

    Calculation issues.

    I am having a hell of an issue that i can not figure out. So I have 6 teams with three months of data I need to track. Each team has a goal they need to achieve each month based on how many people are on that team. This goal changes with the number of people on the team. This is at the bottom of...
  3. D

    Percentage of a percentage?

    I better explain this right, i would like to present in a cascade chart the participation of a category in the percentage fraction out of goal. Any guide will be highly appreciated. From the table below in PowerBI I have the following: On Goal = 8/18 = 44% What i would like to present is the...
  4. E

    Change Events with multiple instances of Excel

    I am using the multithread tool by Tomasz Kacprowicz at http://analystcave.com/excel-vba-multithreading-tool/ Usually this tool works great but is failing for a new model in which a Sheet_Change event is used to automate the goal seek function. When the model is run with only 1 instance of...
  5. M

    Goal Seek not working in my office 365

    Hello Evryone I have a problem in my office 365, in using goal seek When I use it, it change the set value by the value i has entered without changing the cell that must be changed This is an exemple A1 = 1 / A2= 2/ A3= A1+A2=3 (My goal is to have 100 in cell A3 by changing A1=> The...
  6. V

    Goal Seek or similar to amend several cells rather than just one

    Say there is a value in cell E1, which has been calculated from the contents of cells in column D. With Goal Seek one can alter the number at E1 by changing one of the cells in column D. Rather than altering a single cell in that column, should I need to more than one to obtain the required...
  7. S

    Goal Seek Analysis "If cells are less than 0, than 0" isn't working.

    WhatIfAnalysis Macro ' ' Keyboard Shortcut: Ctrl+g ' Public Sub GoalSeeker() For i = 3 To 187 cells(i, "AG").GoalSeek Goal:=0.15, ChangingCell:=cells(i, "AF") cells(i, "AF") = WorksheetFunction.Round(cells(i, "AF"), 2) cells(i, "AF") < 0 = 0 Next i End Sub
  8. A

    Goal Seek shows correct answer but won't stop iterations

    I am running goal seek on two different workbooks. WB1 has an interest rate that modifies the value of the other workbook via basic multiplication. I am goal seeking the sum of the products. When I step through the goal seek iterations, it lands precisely on the sum I want. But goal seek...
  9. N

    If, and, or

    Scenario: I am trying to find the best way to search one row across ten non consecutive columns to see if criteria is met. This row is one of a thousand and the columns are ten of ninety-five. My goal is: If B3="V" AND AF3="B" AND Q3-AQ3 <=|2.25| OR AH3="B" AND Q3-AS3 <=|2.25| OR AJ3="B" AND...
  10. crystalneedshelpplzthnx

    Using an "indirect" formula without a cell reference

    Hello, I'm not sure if something like this is possible, but if "Indirect" is possible, I'm sure there is a way to achieve my goal. Here is my dilemma. There is a formula I need to use: (formula 1) =T:T&" "&IF(AA:AA<16,1,IF(AND(AA:AA>15,AA:AA<31),2,3)) Example output would be: AM DIY 3.2OZ...
  11. M

    Is there a formula that adds, subtracts, multiplies, and or divides two digit numbers in a single cell?

    Are there formulas that will add, subtract, multiply, and/or divide data from two-digit numbers in a single cell? I appreciate any help I can get. Thank you in advance.
  12. M

    How to handle percentage to goal with 0 and a negative number

    Hello! In my day to day job, we have goals set (for each month) that can be either positive or negative "net adds", and I can reach negative or positive actual net adds by the end of the month. I am having issues getting excel to populate my percent to goal under the following parameters: My...
  13. T

    Matching and summing matches to distinct values for multiple rows over multiple columns with blanks

    My data has multiple pairs of a "name column" and "hour column" that corresponds to third value in another "movie column." The names aren't always the same in each column and can sometimes be blank or repeat. I'm trying to match and sum across all of these columns. The end goal is to have a what...
  14. L

    Need 2 Formulas

    I do a Financial Spreadsheet for my boss. Lets say A1 is our revenue. B1 is staff cost. C1 is a percentage of cost to revenue. D1 is the difference of C1 to our Goal of 22.5% Is there a way C1 can turn Red if the Percentage exceeds our Goal of 22.5? Is there a way D1 can be Red if the...
  15. S

    goal seek using vba ?

    I have a macro that calculates a function. There re 3 inputs to the function Often I use the excel spreadsheet to do a goal seek to set the result of that faction by allowing one of the inputs to vary Is there a simple way to program this in vba or do I basically have to write a complete...
  16. T

    Target Calculation formula

    Below is a sample table i'm working on. We have an opening number for each member in B and a target closing number in C. Column D is the actual closing number. e.g. Mem5 target is 17,000 and closing is 17,000, Column E should show 100%. Mem4 target is 18,400, but opening and closing are same at...
  17. R

    Formula Help| Finding Time depending on attempts

    Hi Guys, I have a table like this: <colgroup><col><col><col><col><col></colgroup><tbody> Current Attempts Current Average Time Goal Remaining Attempts Time I need to get to goal 50 250.00 210.00 25.00 > help here < </tbody> I'm looking for a formula on how much time I need to get to my...
  18. M

    Goal seek

    Hi guys, Im looking for a sub goalseek that involves a loop making U8:U207 = 0 by changing the values in b2:q12 thank you
  19. V

    Conditional Formatting & VLOOKUP

    Hi, I can't seem to get this to work. Any assistance would be greatly appreciated. I am trying to use conditional formatting on sheet 1 to highlight green any sales months that the seller was over goal based on their goal data on sheet 2. Sheet two contains the seller's goal data. I need to...
  20. X

    Goal seek with Rand values

    Hi Folks. I'm looking to randomize some of the inputs to a goal seek calculation that I can run multiple times for different random values. This creates the problem of goal seeking on continually generating random values which doesn't work. is there a way to freeze the random values functions...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top