| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using an If statment to find out if A is B, but <C
What I am tryin to do is have a cell to determine if someone has intermediate
experiance based on the number of months worked. Someone would be considered intermediate if they have worked more than 7, but less than 15 months. Any help would be great!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using an If statment to find out if A is B, but <C
=if(and(A1<15, A17), "Between", "Not Between")
-- HTH... Jim Thomlinson "kmt1984" wrote: What I am tryin to do is have a cell to determine if someone has intermediate experiance based on the number of months worked. Someone would be considered intermediate if they have worked more than 7, but less than 15 months. Any help would be great!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using an If statment to find out if A is B, but <C
Now this brings up another questions.... At the top of the colum I am trying
to count the number of Intermediate employees using a counted if statement. Any help there? "Jim Thomlinson" wrote: =if(and(A1<15, A17), "Between", "Not Between") -- HTH... Jim Thomlinson "kmt1984" wrote: What I am tryin to do is have a cell to determine if someone has intermediate experiance based on the number of months worked. Someone would be considered intermediate if they have worked more than 7, but less than 15 months. Any help would be great!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using an If statment to find out if A is B, but <C
=sumproduct(--(A2:A1000 < 15), --(A2:A1000 15))
Here is a link to how that function works... http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "kmt1984" wrote: Now this brings up another questions.... At the top of the colum I am trying to count the number of Intermediate employees using a counted if statement. Any help there? "Jim Thomlinson" wrote: =if(and(A1<15, A17), "Between", "Not Between") -- HTH... Jim Thomlinson "kmt1984" wrote: What I am tryin to do is have a cell to determine if someone has intermediate experiance based on the number of months worked. Someone would be considered intermediate if they have worked more than 7, but less than 15 months. Any help would be great!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using an If statment to find out if A is B, but <C
Hi,
=IF(B1<=7,"Beginner",IF(B1<15,"Intermediate","Adva nced")) Where the number of months are in column B. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "kmt1984" wrote: What I am tryin to do is have a cell to determine if someone has intermediate experiance based on the number of months worked. Someone would be considered intermediate if they have worked more than 7, but less than 15 months. Any help would be great!! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using an If statment to find out if A is B, but <C
Thanks both of you for all your help. It is greatly appriciated!!
"Shane Devenshire" wrote: Hi, =IF(B1<=7,"Beginner",IF(B1<15,"Intermediate","Adva nced")) Where the number of months are in column B. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "kmt1984" wrote: What I am tryin to do is have a cell to determine if someone has intermediate experiance based on the number of months worked. Someone would be considered intermediate if they have worked more than 7, but less than 15 months. Any help would be great!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If statment help | Excel Worksheet Functions | |||
| IF Statment | Excel Discussion (Misc queries) | |||
| IF Statment | Excel Worksheet Functions | |||
| If statment if its possible. | Excel Discussion (Misc queries) | |||
| If statment | Excel Worksheet Functions | |||
Hybrid Mode
