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")))))))
Print Post      Close Window