Re: Excel Help!
Posted 4/5/2012 4:48:36 PM by Andrewz00


Posted by rkl1130
=IF(E8<=10,"$1-$10M",IF(10<E8<=25,"$10-$25M",IF(25<E8<=50,"$25-$50M",IF(50<E8<=75,"$50-$75M",IF(75<E8<=100,"$75-$100M",IF(100<E8<=150,"$100-$150M",IF(150<E8<=200,"$150-$200M")))))))



i would re-write the second condition...

instead of if(10<E8<25...

i would write if(and(E8>10,E8<25)...

if(E8<10, "$1--" ,(
if(and(e8>10,e8<=25), "$10-.."

Print Post      Close Window