| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| if statemant | Excel Worksheet Functions | |||
| How do you write a T with a bar on it? | Excel Discussion (Misc queries) | |||
| How to write a macro?? | Excel Discussion (Misc queries) | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| How to I write a UDF? | Excel Discussion (Misc queries) | |||
Hybrid Mode
