Forum Discussion
Need Help with Nesting multiple If and statements
Hello Everyone, i am working on a spreadsheet that will allow me to prompt data based on different scenarios from drop down menus. The problem i am running into is that i have capped out the allowe...
I would try to set up a table that contains the values for each scenario and then use a lookup function to match the specific scenario to the table entries.
For some of the conditions that are testing number values, you may need to set up a MIN and MAX column if the condition has several different thresholds. Just be mindful that you should not set overlapping MIN/MAX ranges (where you are testing for <=100 and >=100 instead of <=100 and >100).
I attached a small example. Since the formula is an array formula, you may need to hit Ctrl+Shift+Enter if you don't have office 365 and dynamic arrays.