if between function as a single argument

Is there a non-macro "in between" function that uses only one argument?

eg.

If A1 is greater than 10 and less than 50, return YES.

I know I can use:

if(and(A1>10,A1<50),"yes","no")
or
if((A1>10)*(A1<50),"yes","no)

however, in both situations it uses 2 arguments and there is a limit to 8 argumnets per function - I am trying to put together a longer formula

Any ideas? All help is appreciated.

Originally Posted by options

Is there a non-macro "in between" function that uses only one argument?

eg.

If A1 is greater than 10 and less than 50, return YES.

I know I can use:

if(and(A1>10,A1<50),"yes","no")
or
if((A1>10)*(A1<50),"yes","no)

however, in both situations it uses 2 arguments and there is a limit to 8 argumnets per function - I am trying to put together a longer formula

Any ideas? All help is appreciated.

I'm not sure what you mean by there being a limit. There's a limit of 7 to the number of IF() statements you can use in a single formula. Is this what you're getting at?

If you're devising a formula that contains more than 7 IF() functions then there is likely to be another approach, probably involving the (in my opinion) superior and more flexible SUMPRODUCT() functions.

What's the structure of the longer formula?

Rgds