Worksheet function needed
 

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

Worksheet function needed
 

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

Worksheet function needed
 

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

Worksheet function needed
 

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

Worksheet function needed
 

Try this:

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


"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