Thread: Using an If statment to find out if A is B, but <C
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default 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!!
Reply With QuoteReply With Quote