Hi

=IF(A119999999,"E $20M",
IF(A19999999,"D - $10m - 20M",
IF(A14999999,"C - $5M-$10M",
IF(A1999999,"B - $1M-$5m","A - <$1m"))))

--
Regards
Roger Govier

"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!!!