On Nov 2, 7:30*am, Ymtrader wrote:
The only way I know how to do this is with a really ugly nested IF
statement. *Is there a better way?

I have 8 "zones" of numbers and I need to determine which zone this
number fits into.

* * * zn1 * * * * * * * zn2 * * * * * * * * zn3
zn4 * * * * * zn5 * * * * * * *zn6 * * * * *zn7
zn8
1410 *1416 * * * 1416 *1421 * *1421 1423 *1423 1436 *1436 1437 *1437
1439 *1439 1445 *1445 1450

If I need to know what zone number 1422 fits into I can only to think
of a nested IF statement:

IF(P2G2,IF(P2<H2,"ZN3").......................... ..........................*....................... ........................................)

I am thinking there must be an easier more efficient way. *Any ideas?
Thanks!

Har zn1 zn2 zn3
zn4 zn5 zn6 zn7
zn8
1410 1416 1416 1421 1421 1423 1423 1436 1436 1437 1437
1439 1439 1445 1445 1450

Hard to tell from your broken paste
"If desired, send your file to dguillett @gmail.com I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results."