Hi Guys, here is the problem:
Cells G3, H3, and I3 are populated with any of the following data (for the respective columns):
Aaa AAA AAA
Aa1 AA+ AA+
Aa2 AA AA
Aa3 AA- AA-
A1 A+ A+
A2 A A
A3 A- A-
Baa1 BBB+ BBB+
Baa2 BBB BBB
Baa3 BBB- BBB-
Ba1 BB+ BB+
Ba2 BB BB
Ba3 BB- BB-
B1 B+ B+
B2 B B
B3 B- B-
Caa1 CCC+ CCC
Caa2 CCC CCC
Caa3 CCC- NR
Ca CC
C C
NR NR
Now in Cell AA3 of my workbook, I wish to input the following formula using a macro:
=IF(OR(G3="Aaa",G3="Aa1",G3="Aa2",G3="Aa3",G3="A1",G3="A2",G3="A3",G3="Baa1",G3="Baa2",G3="Baa3",H3="AAA",H3="AA+",H3="AA",H3="AA-",H3="A+",H3="A",H3="A-",H3="BBB+",H3="BBB",H3="BBB-",I3="AAA",I3="AA+",I3="AA",I3="AA-",I3="A+",I3="A",I3="A-",I3="BBB+",I3="BBB",I3="BBB-"),"IG",IF(OR(G3="Ba1",G3="Ba2",G3="Ba3",G3="B1",G3="B2",G3="B3",G3="Caa1",G3="Caa2",G3="Caa3",G3="Ca",G3="C",H3="BB+",H3="BB",H3="BB-",H3="B+",H3="B",H3="B-",H3="CCC+",H3="CCC",H3="CCC-",H3="CC",H3="C",I3="BB+",I3="BB",I3="BB-",I3="B+",I3="B",I3="B-",I3="CCC+",I3="CCC"),"HY",IF(AND(G3="NR",H3="NR",I3="NR"),"NR")))
However there seems to be some syntax error in the R1C1 code that I am using inside the macro...could you guys help? thanks!
Bookmarks