I think you are looking for:

=IF(I2<1000000,"A - <$1M",IF(I2<5000000,"B - $1M-$5M",
IF(I2<1000000,"C-$5M-$10M",IF(I2<20000000,"C-$10M-$20M","E-$20M+"))))

Hint: when you write formula think about overlap and gaps - how would your
starting formula cope with 999999.5?

I recommend against many levels of nested If. Vlookup is usually easier to
understand and maintain.

http://www.contextures.com/xlFunctions02.html

Your vlookup formula would look something like:

=VLOOKUP(I2,"yourVlookupRange",2)

The table would have values to look up in column 1 and lookup value in
column 2.

--
Steve

"HS" wrote in message
...
Hi, I am trying to create a nested if .. I'm guessing this is what I need
but
it's not working

I am trying to categorize total fees

<$1,000,000 = A - <$1M
Between $1,000,000 and $5,000,000 = B - $1M-$5M
Between $5,000,000 and $10,000,000 = C - $5M-$10M
Between $10,000,000 and $20,000,000 = C - $10M-$20M
$20,000,000 = E - $20M+

I started with this but it's not working?
IF(I2<1000000,"A - <$1M",IF(I2999999 and <4999999,"B -
$1M-$5M",IF(I24999999 and <9999999,"$10M-$20M,0)))

thank you!!!