Try:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Euan Ritchie" wrote in message
...
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