Count If
 

How do I write a formula that will return a '1' if an adjoining cells
contains a value between 1 - 7?
Help please - many thanks.

Count If
 

Hi Ean,

Try:

=IF(AND(A1=1,A1<=7),1,0)
--
Hope this helps


"Eán" wrote:

How do I write a formula that will return a '1' if an adjoining cells
contains a value between 1 - 7?
Help please - many thanks.

Count If
 

Try
=IF(AND(A1=1,A1<=7),1,"")

If this post helps click Yes
---------------
Jacob Skaria


"Eán" wrote:

How do I write a formula that will return a '1' if an adjoining cells
contains a value between 1 - 7?
Help please - many thanks.

Count If
 

=--AND(A1=1,A1<=7)

Mike

"Eán" wrote:

How do I write a formula that will return a '1' if an adjoining cells
contains a value between 1 - 7?
Help please - many thanks.

Count If
 

Another one:

=(A1=1)*(A1<=7)

Multiplying is like using AND.
(Adding is like using OR)

Eán wrote:

How do I write a formula that will return a '1' if an adjoining cells
contains a value between 1 - 7?
Help please - many thanks.

--

Dave Peterson