Formula

[dcb1]

May I please have help on the following: I need to put a function/
formula in cell C44 returning an “F” and in cell C45 an “M”. I need
to check column C rows: 9,11,12,13,15,16,18,20,21,23,26,30 to see if
there is a 1. If there is a 1, then return an “F” in cell 44. If any
other numbers, letter(s), or blanks other than a 1 are in these cells,
don’t return anything--- leave cell 44 unchanged. I then need to
check the same column but different rows which are
14,17,19,22,24,25,27,29 to see if there is a 1. If there is a 1, then
return an “M” in cell 45. I then will check these same cells in
column C for a ‘2’ and a ‘3’ putting an 'F' and 'M' in cells C47 & C48
and C50 & C51. I then will check columns D through AF for the same.
I guess it will make it a little tedious since the cells to be checked
are in different rows where I assume a range can’t be used. Also, if
it is not too much trouble, please give me different formulas to solve
this (thanks). However, you can exclude any array formula's where Ctrl
+Shift+Enter are involved. I have recently asked help on formulas/
functions. I am obviously not good with them. Anyhow, I greatly
appreciated all of the help!

 

[JLatham]

Try variations of this formula
=IF(AND(c9=1,c11=1,c12=1,c13=1,c15=1,c16=1,c18=1,c20=1,c21=1,c23=1,c26=1,C30=1),"F","")