I'm trying to create a macro and formula that will work with multiple true conditions. In column I there are numbers, about 40. In column J, I'd like to convert those numbers to text. Some numbers will be AA (true) and others BB (false). I tried over and over to get the formula to work and kept running into missing closing parenthesis errors. The formula below was finally accepted, but alas, it won't copy down to the rest of the cells in the column. What am I doing wrong? Here's the formula I used cell J7:
=IF(OR(I7=9, OR(I7=13,OR(I7=25,OR(I7=26,OR(I7=38,OR(I7=39,OR(I7=40,OR(I7=50,OR(I7=51,OR(I7=56)))))))))),"AA","BB").
The formula work in cell J7 but it won't copy down to the cells below. The value in J8 is also 38. I only included the true numbers. The numbers not included in the true conditions are false (BB). I don't think I need to list them individually, or do I?
Also, how do I create macro language that will include this formula in cell J7 down to the last active row?
Thanks so much for your help.
=IF(OR(I7=9, OR(I7=13,OR(I7=25,OR(I7=26,OR(I7=38,OR(I7=39,OR(I7=40,OR(I7=50,OR(I7=51,OR(I7=56)))))))))),"AA","BB").
The formula work in cell J7 but it won't copy down to the cells below. The value in J8 is also 38. I only included the true numbers. The numbers not included in the true conditions are false (BB). I don't think I need to list them individually, or do I?
Also, how do I create macro language that will include this formula in cell J7 down to the last active row?
Thanks so much for your help.