What is the best way to compare a large set of numbers against a single value. There are 10 cells which have a final value that changes dynamically with user input. Trying to compare this cell against the value range below. I tried a nested IF(AND..) but excel kicked back an error saying there...