Excel less than but greater than [Solved/Closed]

Welshjessy - Feb 3, 2011 at 06:12 AM - Latest reply:  Welshjessy
- Feb 3, 2011 at 06:26 AM
Hello,

How would I get into L2 if J2=>10 then "lates", if J2=<8 then "earlies"

With all others returning an N/A or false

Thanks

See more 

2 replies

coolcat1 12 Posts Thursday February 3, 2011Registration date February 7, 2011 Last seen - Feb 3, 2011 at 06:18 AM
0
Thank you
=IF(J2>=10;"lates";IF(J2<=8;"earlies";""))
0
Thank you
Fantastic! Thanks very much!