remove the ,1,0
=SUMPRODUCT(--(N57<=11),--(N57<=-11),--(Q57<=11),--(Q57<=-11),--(AB57<=11),--(AB57<=-11))
or
=SUMPRODUCT(--(abs(N57)<=11),--(abs(Q57)<=11),--(abs(AB57)<=11))
From your Description You might want "10" rather than 11 in your equations.
a simpler equation
=if(max(abs(M57),Abs(Q57),Abs(Ab57))<=11,1,0)
"Kierano" wrote:

Hi,

I have a formula in which I want to return a 1 to include else a 0 if
certain cells contain a value of + or - 10. Unfortunately this is returning
zeros even when a 1 should be returned.

=SUMPRODUCT(--(N57<=11),--(N57<=-11),--(Q57<=11),--(Q57<=-11),--(AB57<=11),--(AB57<=-11),1,0)

Any help gratefully appreciated.