|
Re: Excel Help!
Posted 4/5/2012 9:27:01 PM by LSP2005 those conditions are redundant since they are in the false part of the first condition. For instance: if the first test is true the value is less than 10, if the first test is false it looks at the second condition - so you don't need to test for > 10 there. The resulting formula is: =IF(E8<=10,"$1-$10M",IF(E8<=25,"$10-$25M",IF(E8<=50,"$25-$50M",IF(E8<=75,"$50-$75M",IF(E8<=100,"$75-$100M",IF(E8<=150,"$100-$150M",IF(E8<=200,"$150-$200M","Over $200M"))))))) |