I need to write a formula that looks at a set of cells and determines if they
equal "F" or if they have numerical value of less than 59 and/or greater than
1. How would I write this? If "F" does not appear in any of the cells, then I
want it to equal "Z". If the numerical value is 0 or greater than 59, I want
it to equal "Z" as well. Thank you for your help.