low

I am trying to calculate the level of risk for a particular item based on the user inputs to two fields. Column A = Impact; drop down of values Column B = Probability; drop down of values Column C = Risk Level; calculated based on the entry in Column A and B and where they intersect in a...

I'm working on a 9-box talent matrix, and what we're trying to do is pull names from a list and into their respective grid square. Everything is working, except for the category of "High-Low." I keep checking the formula, tested tweaks, and even re-created it multiple times from scratch. But I...

I'm working on a 9-box talent matrix, and what we're trying to do is pull names from a list and into their respective grid square. Everything is working, except for the category of "High-Low." I keep checking the formula, tested tweaks, and even re-created it multiple times from scratch. But I...

Greetings, I have not been able to find an answer using search techniques and hoping some one may have a solution for me ... I have a worksheet with a couple of columns that have formulas. The formulas' result is to conclude with either a specific cell's value (it will be numeric) or results...

Hello, I am looking for a formula that will look up in a column from the row I am in and tell me the first 4 unique values it sees ignoring gaps. So that the result should look something like below. So each column row for HHHHLLLL will show the first above values for the High and Low columns. I...

I'm trying to do a concatenate formula to combine all the categories from sheet 1 into one cell. The values in Sheet1 for categories would be a drop down list of blank, L, M, and H. In Sheet 2, if the category has a value, include it in part of the concatenate formula. Is an loaded IF statement...

Hello Everyone, I have two option button : London_Click() and Paris_Click() One text Box : TextBox1_Change() One combo box: DropDown_Change() Under the Combo box I have below items: "High London" "Low London" "High London 2" "Low London 2" "High Paris" "Low Paris" "High Paris 2"...

Hoping you could help me with an IF statement with range of numbers. For example, per the table below, if my value is between the low range (i.e. 137) and high range (i.e. 227), i want Excel to return "Level2", and so on <tbody> low high level # <colgroup><col...

New user here in need of help. I am creating a mixture design using 3rd party software and needhelp setting up the constraints. I’m using Excel to do the math and willput it into DOE software. What the DOE softwaredoes is it looks at the high and low ranges that you enter, and it...

Hi, I am pretty decent with Excel, but wanted to know if there is an efficient way of modelling this, without having numerous if statements and vlookups. Scenario: What I have: - Data Table containing amounts labeled by a chronological key 1 through 100 with letters assigned to each amount. -...

Hello all! MrExcel newbie here. I'm trying to create an If statement, I'm assuming an If statement, that can define a cell based on where it falls in a range of numbers. It's for housing development project. I'm attempting to solve for the Status As shown below, if the resident earns above...

I've tried so many options but it only seems to return one answer. E.g. The values I have are [A1] 41, [A2] 0.08, [A3] -2 and [A4] -13. In B1 I have: =IF(A1>5,"High",IF(A1<-5,"Low","Mid")) This returns "High", which is correct. But I drag it down into B2, B3, B4 and the cell ref A1 changes to...

Hello, My script gives a randomly generated number between a range of numbers the user specifys. Take 2100 and 2199. The script will generate a random number between those numbers. But before the script generates the number - I want to compare it too a list on another sheet to see if the number...

Hi all, Any help would be appreciated. I am trying to create a way to model some data in Excel. This involves taking three sections (lets call them a,b,c) and their sub-sections (lets call them A1, A2, A3, A4, B1, B2, B3, B4, B5, C1, C2, C3) and adds individual confidence ratings to these sub...

Hi All, I'm having an issue with an excel INDEX and MATCH formula for the risk matrix below. The formula I've used is: =IFERROR(INDEX('OHS Risk Matrix'!$C$4:$G$8,MATCH(C24,'OHS Risk Matrix'!$C$3:$G$3,0),MATCH(B24,'OHS Risk Matrix'!$B$4:$B$8,0)),"") It looks like it worked perfectly, however...

In tab1, I have a table with the end user will complete: <tbody> Type Check 1 Check 2 Check 3 Check 4 Check 5 Check 6 Check 7 Check 8 Check 9 Combined Check Type1 L M L H H Type2 M L M M M </tbody> In tab2, Column B is what I'm attempting to get as an end result. I can't...

I have a sheet that looks like the below (except 4k rows and between 1 and 79 columns) I would like to extract all the unique values into one row or column so I can see what all of these unique values are. Removing duplicates does not seem to be working. <thead style="margin-left: 0px...

Hi all, Need a favor. <tbody> A B C D E F G 1 2 Risk Profile 3 Low Medium High Score 4 Risk Appetite Low 1 2 3 1 </tbody> I like to have the Score (Cell G4) displayed based on selection made in Cell B4. Example if User choose "Low", Score = 1 Many thanks in...

It seems that the last part of this statement that uses the SEARCH formula is not working (highlighted in red). If cell C2 contains "1%", it will return the correct answer, but if it contains "2% or "4%", then it will return #value . Basically, the formula recognizes the first SEARCH, but not...

<tbody> Item Price Classification A High A Low A Average B High B Low B Average Item A £4.50 A Item B £6.50 B Item C £5.75 B Item A £3.60 C Item B £10.05 E Item C £6.80 C Item A £4.75 B Item B £7.20 A Item C £5.45 B...