|
Excel Help!
Posted 4/5/2012 4:24:03 PM by rkl1130 Hi Guys! I don't know if this is the right place to put this, but I've been working on a formula forever and I just can't seem to find where I've gone wrong and it's annoying me. I'm trying to write an "IF" formula, but it doesn't seem to be working and it's only reading the first condition and everything else is coming out as "FALSE." Can anyone with great excel formula writing skills help. =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"))))))) |