ExcelBanter - solving lists of numbers problems

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - solving lists of numbers problems (https://www.excelbanter.com/excel-discussion-misc-queries/37392-solving-lists-numbers-problems.html)

richard

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

JE McGimpsey

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

All times are GMT +1. The time now is 08:22 PM.