Excel less than but greater than [Solved/Closed]

- 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

Posts
12
Registration date
Thursday February 3, 2011
Last seen
February 7, 2011
- 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!