Excel less than but greater than

Solved/Closed

Welshjessy - 3 Feb 2011 à 06:12
Welshjessy - 3 Feb 2011 à 06:26

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

Réponse 1 / 2

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

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

Réponse 2 / 2

Welshjessy
3 Feb 2011 à 06:26

Fantastic! Thanks very much!