Appears to me that "LOOKUP" could be used, with "No Good" being returned
for the "gaps" in the sequence.

billy boy wrote:

Here is what I have

=IF(AND(E591000,E5<99000),"1-50 &
1-40",IF(AND(E5139600,E5<147000),"4-40's",IF(AND(E5182000,E5<198000),"2-40's
&
2-50's",IF(AND(E5176501,E5<181999),"3-50s",IF(AND(E5161000,E5<167500),"3-40's
& 1-50",IF(AND(E5167501,E5<176500),"3-40's & 1-50 OR
3-50's",IF(AND(E5147001,E5<154500),"4-40's OR 1-40 & 2-50's","No good")))

This is what I want

=IF(AND(E591000,E5<99000),"1-50 &
1-40",IF(AND(E5139600,E5<147000),"4-40's",IF(AND(E5182000,E5<198000),"2-40's
&
2-50's",IF(AND(E5176501,E5<181999),"3-50s",IF(AND(E5161000,E5<167500),"3-40's
& 1-50",IF(AND(E5167501,E5<176500),"3-40's & 1-50 OR
3-50's",IF(AND(E5147001,E5<154500),"4-40's OR 1-40 &
2-50's",IF(AND(E5182000,E5<195000),"3-50's,","No good"))))))))

Thanks






"Gary''s Student" wrote:


Yes...post you need
--
Gary''s Student - gsnu200713