=If(b6<=5,"resistant",if(and(b65,b6<10),"intermed iate","susceptible")

I'm also assuming it's susceptible if it's greater than or equal to 10 (not
less than or equal to 10).

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"xtrmfighter" wrote in message
...
i want it to type "resistant" if b6 is < or = 5
"intermediate" if 5 but <10
"susceptible" if < or = 10

I know i should know how to do this I just can't figure it out with
multiple
conditions. Any help would be greatly appreciated.