How do I write this IF statemant?

[Guest]

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.

 

[Anne Troy]

=If(b6<=5,"resistant",if(and(b6>5,b6<10),"intermediate","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
****************************

 

[Guest]

I assume you mean >=10 is " "susceptible", if so try
=IF(B6<=5,"resistant",(IF(B6>=10,"susceptible","intermediate")))
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Guest]

I think you meant susceptible if > or = 10? if so...
=IF(B6<=5,"resistant",IF(B6<10,"intermediate","susceptible"))

 

[Guest]

yes, thank you.. i did mean to type "if >= 10 then susceptible