Count If

EÃ¡n · Oct 28, 2009

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 · Oct 28, 2009

Hi Ean,

Try:

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

Jacob Skaria · Oct 28, 2009

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

If this post helps click Yes

Mike H · Oct 28, 2009

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

Mike

Dave Peterson · Oct 28, 2009

Another one:

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

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