Hello everyone,
I want to create an index cell based on the information in two previous cells (whose content is given based on a dropdown list). For example, when the risk in cell 1 is "company blackout" and the possibility in cell 2 "80%", I want my index cell to show e.g. "high risk". THerefore, based on the content in cell 1 and cell 2, the index cell should display low, medium or high risk.
How can I do this?
Thanks a lot in advance
what makes that high/low risk...
Can we base it strictly off 80% (Thresholds) or do you have a table that shows Company Blackout and 80% that we would look this information up on... If you could share a sample of your data so those of us that take a look can see what you are working with (Scrub for sensitive info) but make a mock up of what you have currently and what you would like to see. Then we can see about finding a solution
Go Advanced - ALT+X
-If you think you are done, Start over - ELeGault
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks