If Function

G

Guest

How would you write this equation?
If value in cell A2 is between 98 and 112 return the word green, If the
value of cell A2 in between 128 and 131 return the word blue, If the value of
cell A2 is between 140 and 145 return the word black, and if the value of
cell A2 is "clinic" return the word red, anything else return 0.
 
J

Jason Morin

One way:

=IF(AND(A2>=98,A2<=112),"green",IF(AND
(A2>=128,A2<=131),"blue",IF(AND
(A2>=140,A2<=145),"black",IF(A2="clinic","red",0))))

HTH
Jason
Atlanta, GA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top