Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|