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.