|When I am using an IF statement to return values based on input that falls within various ranges of numbers, I prefer to do it backwards since Excel will stop evaluating the function as soon as it hits a TRUE condition.|
It eliminates the need for the AND function and results in a shorter formula.
If you need the cell to be blank if a Zero exists, then just add an IF clause for that:
If your lengths will always be whole numbers, then you don't need to check for >=, just use a value that is 1 less than the number you are trying to test for:
Of course, there is also the VLOOKUP method, which allows the user to alter the table of values and never have to alter the formula if the criteria or desired results change.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.