solving lists of numbers problems

R

richard

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
 
Top