ExcelBanter - IF function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF function (https://www.excelbanter.com/excel-discussion-misc-queries/251431-if-function.html)

Petros

IF function

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

Dave Peterson

IF function

maybe...

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

Petros wrote:

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

--

Dave Peterson

Teethless mama

IF function

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

"Petros" wrote:

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

All times are GMT +1. The time now is 07:03 PM.