Forum Discussion
Formulas that compare data in other cells
create 3 sheets with different scenarios that depicts real scenarios
OK, tell you what. You highlighted the cells in yellow where "Yes" or "No" was requested, which, when entered, caused the cell about which you originally asked your question to not perform as desired. But when I trace back the cells that your original formula referenced (and highlighted them in green background) it turns out that some of them aren't even visible under all circumstances!!!!!!!!!!
And they don't all themselves yield numbers as values, so we're looking for a minimum number (by your original request) from a group of cells that don't always show numbers.
May I suggest you go back to the start and create a much more intelligible worksheet? If, at any rate, you want help. This is like an amusement park game where you're aiming at things in the dark. You may know what all the cryptic or non-existent labels mean, but the rest of us are not mind-readers so can't get behind them.
You clearly know how to write Excel formulas; what you need is some help in laying out a spreadsheet so that it makes sense, so that the various dependencies of one cell on another are evident and reasonable. As it is, it would appear that you yourself are having difficulty making sense of it, and it's not because you don't know how to write Excel formulas.
- OK. Thanks for your input.
- is the No scenario reflected in your shared workbook which also reflects the expected result?
- So what do the "Yes" or "No" responses have to do with the cells that were evaluated by your original or my use of MIN? Obviously the "No" affects one or more of the values that are evaluated. YOU are the one who knows the interrelationships involved.
