Hi all,
| My cols. are months ( Jan thru Dec), A is Jan, B is Feb, C is March and so on.. If, for example A2,B2,B3 etc have "C","Z" or ""(blank- empty cell), then I need "Comp" otherwise "No". With my if statement formula I am only getting "comp". I should get "No" if any of the C,Z or blank cell is missing. IF(OR(A2="c",A2="z",A2="",B2="c",B2="z",B2="",C2="c",C2="z",C2=""),"comp","no") |
