try

IF(AND(MIN(A1:A3)=-1,MAX(A1:A3)<=1),"A Comment","B Comment")

Mike

"Euan Ritchie" wrote:

How can i write a function with the following criteria?

IF 3 cells values are all within a given range,say -1 and 1, then "A
comment", otherwise, "B Comment"

Thanks