Worksheet function needed

[Euan Ritchie]

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

 

[Mike H]

try

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

Mike

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Max]

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
---

 

[Teethless mama]

Try this:

=IF(MAX(INDEX(ABS(A1:A3),))<=1,"A comment","B Comment")