scenario

Hi I have a problem with INDEX/MATCH formula. I have many scenarios writen in second sheet named 'source'. Single scenario has 3 rows with same number of scenario. Column A and B are source for this index/match formula this formula i have in C2 This formula is also in whole C column...

So I am creating a portfolio model for real estate and there is 4 possible ways to purchase a property. Creating 4 different possible cash flows. I need to pull the cash flow based on the way I am purchasing a property and based on which year it was purchased. So for example...

Hi team, I am building an analysis for output for a new machine. I am having some trouble with creating a formula that is adaptable to different ramp-up scenarios , ideally without the use of VBA. Scenario: A machine completes 10 processes a month @ 100% efficiency, but ramp up over the 4...

Hi What-If-->Goal seek (not scenario), set the value of a cell by changing other cells (not only one)? I tried but it seem not working only one value is changing. I think it is not allowed only using Scenario to change 2 or more cells, Am I right? Thanks alot

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

Hi All, i have a scenario where i have a scenario that i have to apply two conditions for a cell: Let say i want to do it for Column A1 1. A1<10 if yes cell interior color should change to Red 2.A1>=10 if yes cell interior color should change to Green can i do this in just one condition...

Hi guys, I have a question regarding drop down lists and how to connect different results on them. My situation is: I have dozens of different scenarios, imagine something like different income statements and all them will show me specific outputs in the end (e.g., profit, cost, etc) I would...

Hello, I'm using excel solver and have a problem I can't figure out. Here's an example: suppose I have 20 suppliers and I want solver to find me the lowest cost based on a set amount of suppliers. For example, I may want solver to give me the lowest cost using only 5 suppliers in one scenario...

Dear All, The solution to this complex problem is beyond my capability and imagination but I know that this would be very simple to many excel gurus here in this forum. Would be grateful , if somebody could suggest a solution & it will save unwanted manual intervention that presently I am...

Excel 2016, Microsoft Office 365 ProPlus Version 1706. I have what seems a trivial error that I can't resolve on my own, and I'm not finding the answer online. I have a spreadsheet with three tabs containing data dumps (from another program) of three scenarios I am comparing (tabs are...

Hi Guys, I'm trying to do some scenario analysis in Excel and am currently populating the table manually. Just wondering, is there a way to generate all possible scenarios within excel using a formula? The first few rows of the table look like below, and as its going to take me until 2018 to...

I am using a couple of spreadsheet applications using Excel. The applications require inputs for certain parameters and then output predicted values. I want to vary the inputs and create a data table showing results for each scenario. Can I do this using easily a combination of macros and...

Hello, I have recently been wondering about this one particular problem. It's about presidential elections in the United States. For those not familiar with how they are conducted, here is how it goes: For each of the fifty states there is a number of presidential electors assigned relative to...

two questions in one here. when i input data into c4 has it has one of 4 answers in it depending on that answer I want to add something to another cell example if c4 says "9 won" then i want to add 3 to d13 if c4 says "18 won" then i want it to add 5 to d13 but if c4 says "lost 9" i want...

Here's fun! :) I'm helping a friend who is trying to work out how much to charge for house calls. He has lots of data. The average house call lasts about 15 minutes, but some as low a 5 mins, some as high as two hours. We're trying to work out if he should have a minimum billiing period, and...

Hi all- I am wasting time on this when I know there is a better way. Trying to analyze various scenarios- two customers we make sales (max capacity to make sales is 3.5 million TOTAL) and recognize net profits at two different percentages (constraints for both go from 0-10%)) One customer has...

Hi, I would like to create a macro to define a new Excel function as follows: =WHATIF(output_ref, input_ref, input_value) The function would calculate the result of a given output cell on changing a specific input cell to an alternative value, for example: A1 = 10 A2 = 20 A3 = A1+A2 = 30 A4...

Hi I have a model in excel which takes a large amount of data and runs it through the model to produce two output numbers. I then have to remove groups of the data while keeping the rest in and pull out the results, then put that group back in and remove the next group and so on. I am trying...