You can't use Letters in your calculation. $10M will not work. You have to
put the correct number without the "M". You are using improper syntax for the
AND function Nd what row in column "A" or "B" are you subtracting from? You
need to use the column and row together like A3 or B45.
--
Dave Herard
MOS Master Instructor
Microsoft Certified Trainer
www.clicknlearnct.com


"HS" wrote:

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