Excel less than but greater than

Solved/Closed

Welshjessy - Feb 3, 2011 at 06:12 AM
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

2 responses

Answer 1 / 2

coolcat1 Posts 12 Registration date Thursday February 3, 2011 Status Member Last seen February 7, 2011 1
Feb 3, 2011 at 06:18 AM

=IF(J2>=10;"lates";IF(J2<=8;"earlies";""))

Answer 2 / 2

Welshjessy
Feb 3, 2011 at 06:26 AM

Fantastic! Thanks very much!