Cnvert Formula to macro

[deviation]

Okay I currently have a lengthy formula using multiple IF statements. I even managed to violate the 7 If statement limit.

However it is extremely slow since it must exeist in all 65536 rows ina work sheet

Is there a way to convert this to a macro that will run if data has been added to the sheet?

I tried using ISBLANK, but then realized it still has to search the cells, it takes about 5 minutes to calcualte and entire worksheet which is why i desie a macro to run faster

=IF(ISBLANK(C2),"",IF(OR(C2="ABSNTU",C2="AFTOUP",C2="ANCNSU",C2="ANCNSP",C2="ABPARU",C2="ABPARP"),IF(C2="ABSNTU","A",IF(C2="AFTOUP","A",IF(C2="ANCNSU","N",IF(C2="ANCNSP","N",IF(C2="ABPARU","P","P"))))),IF(OR(C2="ABSAPU",C2="CONS",C2="REMOVE",C2="AFTOP"),IF(C2="ABSAPU","*",IF(C2="CONS","C",IF(C2="REMOVE","R","V"))))))

 

[shades]

As you approach the limits of the nested IF, it makes sense to consider a Lookup table instead. It appears that this might simplify and speed up your work.