| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to return a value if any numbers in a group meet a criteri
I have a list of say 10 cells in a column with different values. I have
another cell that has a value in it. I need a formula in a 2nd cell, to tell me if any of the numbers in the the group of 10 cells is greater. This may be easier EX: TEST NUMBER = A1 = 10 GROUP A2 = 5 A3 = 5 A4 = 11 A5 = 5 RESULTS CELL = A7 = IF ANY VALUE IN CELLS A2:A5 IS A1, THEN DISPLAY "FAIL" |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to return a value if any numbers in a group meet a criteri
Try something like this:
A7: =IF(MAX(A2:A5)A1,"fail","pass") Does that help? *********** Regards, Ron XL2002, WinXP-Pro "dcozzi" wrote: I have a list of say 10 cells in a column with different values. I have another cell that has a value in it. I need a formula in a 2nd cell, to tell me if any of the numbers in the the group of 10 cells is greater. This may be easier EX: TEST NUMBER = A1 = 10 GROUP A2 = 5 A3 = 5 A4 = 11 A5 = 5 RESULTS CELL = A7 = IF ANY VALUE IN CELLS A2:A5 IS A1, THEN DISPLAY "FAIL" |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to return a value if any numbers in a group meet a criteri
=IF(COUNTIF(A2:A5,""&A1)0,"Fail","")
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "dcozzi" wrote in message ... I have a list of say 10 cells in a column with different values. I have another cell that has a value in it. I need a formula in a 2nd cell, to tell me if any of the numbers in the the group of 10 cells is greater. This may be easier EX: TEST NUMBER = A1 = 10 GROUP A2 = 5 A3 = 5 A4 = 11 A5 = 5 RESULTS CELL = A7 = IF ANY VALUE IN CELLS A2:A5 IS A1, THEN DISPLAY "FAIL" |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula to return a value if any numbers in a group meet a cri
Thanks for the help. Both suggestions work.
"Bob Phillips" wrote: =IF(COUNTIF(A2:A5,""&A1)0,"Fail","") -- HTH Bob Phillips (remove nothere from email address if mailing direct) "dcozzi" wrote in message ... I have a list of say 10 cells in a column with different values. I have another cell that has a value in it. I need a formula in a 2nd cell, to tell me if any of the numbers in the the group of 10 cells is greater. This may be easier EX: TEST NUMBER = A1 = 10 GROUP A2 = 5 A3 = 5 A4 = 11 A5 = 5 RESULTS CELL = A7 = IF ANY VALUE IN CELLS A2:A5 IS A1, THEN DISPLAY "FAIL" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Match Last Occurrence of two numbers and Return Date | Excel Worksheet Functions | |||
| Need help w/ Weight Formula | Excel Discussion (Misc queries) | |||
| Need help w/ "Weight Formula" | Excel Worksheet Functions | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
