Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet function needed | Excel Worksheet Functions | |||
Function needed | Excel Worksheet Functions | |||
Function Needed! Please Help! | Excel Worksheet Functions | |||
help needed in worksheet function | Excel Worksheet Functions | |||
Needed: worksheet export help | Excel Discussion (Misc queries) |