Count If

[Eán]

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.

 

[JudithJubilee]

Hi Ean,

Try:

=IF(AND(A1>=1,A1<=7),1,0)

 

[Jacob Skaria]

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

If this post helps click Yes

 

[Mike H]

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

Mike

 

[Dave Peterson]

Another one:

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

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