Excel 2007 : If condition

**sriramakella23** · 06-21-2010, 04:58 AM

Hi,
Thanks for the reply.. i need numbers like <10 it should display 1 TL, <=10 and >=20 CSAs it should be display 2 , >=20 and <=30 3 for TL and for QTL <=15 1 QTL and >=15 and <=30 2 QTLs etc.

Thanks

**sriramakella23** · 06-21-2010, 05:02 AM

IF((B2-MOD(B2,10))/10=0,1,(B2-MOD(B2,10))/10). i have tried using this formula. but i need for 11 CSA one TL.
Thanks

**pike** · 06-21-2010, 05:17 AM

Originally Posted by sriramakella23

Hi,
Thanks for the reply.. i need numbers like <10 it should display 1 TL, <=10 and >=20 CSAs it should be display 2 , >=20 and <=30 3 for TL and for QTL <=15 1 QTL and >=15 and <=30 2 QTLs etc.

Thanks

which one, >=20 can only be 2 or 3 not both?

**sriramakella23** · 06-21-2010, 06:36 AM

Ok for 1 to 10 CSA 1 TL, 10 to 20 CSAs 2 TLs, 20 to 30 CSAs 3 TLs and so on.
and for QTL 1 to 15 CSAs 1 QTL, 15 to 30 CSAs 2 QTLs, 30 to 45 3 QTLS and so on..
Thanks