scenarios

I've got a set of values (upper and lower limits of ranges) which I use in conditional formatting. This set of values should change depending on the input in the user form. At the moment there are 3 options but it might be more. So I have created 3 scenarios for these options. Now I need to...

Hi Please can you assist with the following problem that I have. I am trying to bring back a value based on three scenarios. The current formula I have is quite simple SUMIF($AZ3,BE$2,$BW3) but I would now like to add to this for two further scenarios. I think it would be something like...

Hi everyone, I am running a brief simulation with VBA where one variable (call it x) affects the output (call it y). The variables are two time series (x1,x2,...,x10 and y1,y2,...,y10). I just implemeted the code to run 200 simulations at once and get the average values for x and y for each...

Hello, This is my first post on MrExcel. I've learnt how powerful tables and pivot tables are for generating views/reports of tabular data. As a result, I've taken production supply data at my company and put it into a table and have created views/reports that others can just refresh each time...

Hello, I am trying to get the following statement to work, but I get a debug, based on the code up to then... can someone tell me what i need to change to get this to run. effectively there are two scenarios which should return "on target". If Cells(j, 30) >= 2 And Cells(j, 26) >= 6 Or...

I get data from various sources and have to create user login IDs that are consistent. I would like help getting one formula (not a macro) that will create the correct ID for all of the different scenarios. Here are more details: User ID requirements: All numbers (no letters or other...

Hi, I am using If clauses to create 4 different scenarios for some modelling. My output is the total number of products for 2018, 2019, 2020, etc. Right now I can change a drop-down and I see the number of products changing in each year. I would like to somehow be able to create an output sheet...

Hi Excel Gurus, I'm trying to write a formula in my report as below, but it only returns error "#VALUE!". There are the scenarios: If the value is a number or contains "-", equals L12 If else, leave it empty. =IF(OR(ISNUMBER(E12),FIND("-",E12)>1),L12,"")...

Hello ...... I have Cells A B C A & B will have numbers 1 thru 20......no zero's or negative numbers I need C to be 1 if criterias are met .......0 if not met Criteria: if A is 1........B can be anything.............C gets a 1 if A is 2........B must be >=7.................C gets a 1 if A...

Hi! First of all, thanks in advance to everyone that saved my sorry a** more times that I can imagine, since I've been visiting this site regularly for tha past 5 years and always found a solution. First time posting, though. :eeek: The problem is (or seems to be) fairly simple, I have to...

I am building a template that has the revenue forecast over time and multiple different scenarios will be run through this ONE single template. There are some scenarios where revenue cuts off at 2022 for example and some where it cuts off at 2052. Thus, I have to have the same chart, but since...

Hi. I have two spreadsheets with results from som tests that I run. I The first spreadsheet may have extra rows that are not in the second sheet. The second sheet may have rows that aren’t in the first sheet. I would like to capture both these scenarios as well as capture differences in the...

My data are like This <tbody> TotalFeed Col1 Col2 Col3 Factor1 Factor2 Factor3 100 (sc-1) 50 25 25 =50/100 =25/100 =25/100 100 (sc 2) 70 =70/100 ? ? 100 (sc-3) 70 15 =70/100 =15/100 ? </tbody> As a matter of math its easy the 30 % remaining will be allocated as 15% and 15 % ...

Hi, I need a macro that can change the value of a specific cell to all of the values in the rows beneath it, stopping when it reaches a blank cell. Each time the cell is changed, the spreadsheet needs to calculate (equivalent of pressing F9) before moving onto the next row. In my example...

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)...

Hi, First time poster here hoping someone can help. I have a set of scenarios (about 500) each with 10 variables that all feed a financial model on another tab - currently with a vlookup. I would like to create a macro or use another function to return the output of the model (it happens to be...

Okay, I made a spreadsheet where you can choose an interest rate in one cell and you can automatically see how it impacts the prices of different securities. This spreadsheet is linked by another one, that recomputes all cash-flows against the new interest rate. Now all the securities are...

Folks, Please save me from lunatic asylum! I want to position the focus onto certain specific cells, each of which I have defined as named ranges. Effectively these are starter cells for distinct sets of calculations. I want to give the user a choice of which starter cell to use. I want...

I have a very complex set of formulas which take in two static numeric input parameters, and results in two values. For example: Input Parameters (B1, B2) Salespeople Profit Margin Output Values (B3, B4) Revenue Profit I manually manipulate my two input parameters, and the...