Formula
Try variations of this formula:
=IF(AND(c9=1,c11=1,c12=1,c13=1,c15=1,c16=1,c18=1,c 20=1,c21=1,c23=1,c26=1,C30=1),"F","")
"dcb1" wrote:
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,
dont 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 cant 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!
|