what-if

  1. A

    Setting the Current Value from a Cell in a Form Control Scrollbar

    I have a file and created 3 scrollbars to help my sales reps understand how they can affect their commissions by activities they can control. On the worksheetI have a section that shows their current performance, and another section that shows a 'What-If' scenario. As I move the scrollbars, the...
  2. C

    What-if analysis of only ONE variable change?

    I have used what-if analysis, when I have 2-D table with 2 variables. i.e. if variable 1 has 10 different values and variable 2 has 7 different values, result table would be 70 results. However, sometimes I need what-if analysis of only one variable that could have 1-X different values. It...
  3. T

    Change a cell based on the active "What-if" scenario name - preferably via formula

    I would like to change a cell based on the name of the active scenario in the "What-if" scenario manager. I would prefer to do this via a formula within the cell rather than VBA/macro coding. For example, to create a row label, or to make the value of the cell TRUE or FALSE based on the name...
  4. L

    Question: Excel 2016 What-if statement

    I am thinking about applying a what-if analysis to find out the one time cost for a LED bulb but I am not sure if the what-if analysis should have a two variable (separate fixed and variable cost) or a one (only variable cost) and how I formulate such a what-if condition. I am enclosing a...
  5. L

    Solver in excel 2010

    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
  6. R

    Dynamically change data for different scenarios?

    Hi - I'm trying to create a way for different scenarios for an income statement (table in worksheet 1). I would ideally like to have a drop down list that calls data from worksheet 2 and populates worksheet 1. Help? The source of scenario data is layed out as follows (table in worksheet 2)...
  7. B

    Advanced What-If Analysis

    Hi All, I'm looking to do a two-variable what-if sensitivity analysis, however, instead of just doing a simple sensitivity to a row cell and a column cell, I would like to shift an entire array as the column and row variables (see below). The reason being that I have multiple "consumer...
  8. P

    Simple Macro for Sensitivity Analysis

    Hi, Ive used data tables a fair amount in excel but given the time they take to recalculate (i have many in one s/sheet) im looking to create a macro rather which only runs when i choose to run it, but I've never really used macros before so am hoping for an easy example to get started. Ive...
  9. keks

    'Goad seek'-like function - urgent

    hello this best-in-the-universe excel board pls somebody tell we if what i have on my mind is practically possible: i want to put together a user-defined function that tells 'what Cell A shoud be for Cell B to equal N'. hope explaintation is clear. thanks!

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top