How do I write this IF statemant?
 

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.

How do I write this IF statemant?
 

=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.

How do I write this IF statemant?
 

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

Ice Hockey rules (especially the Wightlink Raiders)


"xtrmfighter" wrote:

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.

How do I write this IF statemant?
 

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

"xtrmfighter" wrote:

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.

How do I write this IF statemant?
 

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

"Anne Troy" wrote:

=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.