Hi,
I would like an IF statement to look up the following conditions and return text strings dependent on the results:
If the value in Cell A1 is >=27 and <=33 return *White"
or
If the value in Cell A1 is >=55 and <=65 return *Blue"
or
If the value in Cell A1 is >=42 and <=48 return *Yellow"
or
If the value in Cell A1 is >=85 and <=95 return *Green"
or
If the value in Cell A1 is >=115 and <=125 return *Pink"
or
If the value in Cell A1 is >=126 and <=144 return *Orange"
or
If the value in Cell A1 is >=177 and <=183 return *Grey"
or
If the value in Cell A1 is >=207 and <=213 return *Violet"
or
If the value in Cell A1 is >=202 and <=228 return *Purple"
or
If the value in Cell A1 is >=235 and <=245 return "Indigo"
or
If the value in Cell A1 is >=262 and <=275 return *Red"
or
If the value in Cell A1 is >=295 and <=305 return *Light Grey"
or
If the value in Cell A1 is >=327 and <=333 return *Dark Grey"
or
If the value in Cell A1 is >=312 and <=318 return *No Colour"
Managed to get the following to work
=IF(AND((B3)>=55,(B3)<=65),"Blue")
but not for multiple conditions,
Terry
Bookmarks