without VBA, how do I display the word "Fail" in cell 'C2' if any cell in an array contains the letter "F"? The array is not the entirety of column 'A' rather just A1:A30.
Additional info:
the array contains only two letters, which are either the letter "P" or the letter "F". If any one (or more than one) of those cells contains the letter "F" then the result is "Fail".
Kind thanks,
Eddie
Additional info:
the array contains only two letters, which are either the letter "P" or the letter "F". If any one (or more than one) of those cells contains the letter "F" then the result is "Fail".
Kind thanks,
Eddie