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