IF function

[Petros]

How do I enter a double argument in a single function, eg < 10, but greater
than 0.

 

[Dave Peterson]

maybe...

=if(and(0<a1,a1<10),"between","not between")

 

[Teethless mama]

=SUM(COUNTIF(A:A,{">0",">=10"})*{1,-1})