| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
solving lists of numbers problems
i am trying to search through lists to return a result of if there is no
number 5 in cells A1 to A25 then the answer is 5. i am sure it is simple but i must be too stupid to do it -- regards Richard |
|
#2
|
|||
|
|||
|
One way:
=IF(COUNTIF(A1:A25,5)=0,5,"") In article , "richard" wrote: i am trying to search through lists to return a result of if there is no number 5 in cells A1 to A25 then the answer is 5. i am sure it is simple |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| solving for all possible combinations of a set of numbers | Excel Worksheet Functions | |||
| Checking Winning Numbers in the Lottery. | Excel Discussion (Misc queries) | |||
| How do I compare two lists of numbers? | Excel Worksheet Functions | |||
| problems entering in numbers | Excel Discussion (Misc queries) | |||
| finding common numbers in large lists | Excel Worksheet Functions | |||
Hybrid Mode
