risk

Hi All, I have a table with a number of risks in it across 50+ departments. I have a formula which provides me with the top 5 risks (based on risk score) across the entire building as a whole, however, I want to adapt this so that when I change the department via a combo box with a Cell Link...

Hello, Is there a way to combine these in one cell? I want to return the word "Orange", or "Red" or "No Risk". Is that possible? I've tried a bunch of different ways and I can't seem to make it work :( =IF(AND(H3 = "Y"),AND(E3<15, E3>0)) = "Orange" =IF(AND(H3 = "Y"),(E3=0)) = Red Else "No Risk"

Some help here would be much appreciated in figuring out how to do this, as I feel it should be quite possible. I would like to create auto-populating lists of "To-Do's" based off of risk assessment levels, creating a task list that is ultimately sorted by likelihood. For example. I created...

Hi everyone, I am using Excel 2010 and I would like to be able to colour a cell in relation to the risk status i.e. red, red/amber, amber/green, green and the shades in between each. I do not want to put any text in the cells, I would just like a way of being able to change the colour of the...

Hi Guys I am trying and struggling to create a nested IF statement for risk assessment that works this way: The risk factor is calculated by multiplying the consequence(ranges from 1-7) and probability(ranges from 1-9). Based on the product of the two the values can be categorised as very low...

Hi, I'm trying creating a stock portfolio selector wherein the end user gets to choose the portfolio that he would like to have which will based on multiple criteria such as industry, size etc. One of the final steps is to allocate the stock randomly (after the initial filter based on their...

I need to generate a calculated cell (high risk vs. low risk) based on the following criteria of 4 other cells: 1. Number of hospital readmission within 30 days of discharge in the past year : 1 readmission = 2 points 2. Number of ED visits in the last 6 months : 1 ED visit = 2 points 3. Number...

HELPPPPPPPPPPPPP... I have just joined a new team at work and we dont have an MI team yet. no one in my team can do anything excel related other than opening up a sheet and thats about it. i really need some help creating a risk dashboard that shows the top 10 individuals in certain areas...

Hello, I'm trying to use Excel for a risk assessment where users will select the likelihood and consequence of something occurring, and the spreadsheet will then provide the rating and a value attached to it. I am using dropdowns for the likelihood and consequence, then an INDEX MATCH...

Hi, I'm new to the board hoping for some friendly insight.. I'm trying to find a means to calculate a probability of default trend line over a certain period using the TREND function in Excel 10. My issue is the probability figure cannot be less than zero, however I'm not sure how to configure...

I am looking for some assistance on making this assessment worksheet function correctly. I have a column for the Likelihood and a column for the severity I would like to combine the likelihood and the Severity to come together to make the Risk Level ie. Frequent and Hazardious make for a High...

My problem is pretty simple but the solution seems pretty complicated. I have a list of clients and I have data about each one (gender, age, location, profit margin, fin. ratios, industry, favorite color, etcc.. ) I work for a lending institution so I also know how late they were in making...