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

Assume the 3 source cells in A1:C1
Then in D1, copied down:
=IF(COUNT(A1:C1)<3,"",IF(MIN(COUNTIF(A1:C1,"=-1"),COUNTIF(A1:C1,"<=1"))=3,"A comment","B comment"))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,000 Files:362 Subscribers:61
xdemechanik
---