Formulas that compare data in other cells

gpecoraro 

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.