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