Thanks for responding Im not trying to calculate anything just hoping to look
at a value in Column I and then categorize it by placing the letter it's
easier to sort it ..

So, if the total fees in Column I are less than $1,000,000 then I want to
tag it in a category of <$1M? Can this be done?

thanks :)
"DJH6064" wrote:

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