MACRO FORMULA:Write FORMULA manually instead of VLOOKUP IN VBA

Hi,

Column N: Im using vlookup, but i prefer to change it to formula below since macro running slow if i using it. But the formula didnt run as well. Can help?

Im really a new beginner in VBA, my macro is auto recording. Can it be simplified?

Activecell.FormulaR1C1= _ " IF(H3="O6","6%",IF(H3="H6","6%",IF(H3="OD","6%",IF(H3="OA","6%",IF(H3="OC","6%",IF(H3="I6","6%",IF(H3="IM","6%",IF(H3="IB","6%",IF(H3="IH","6%",_
IF(H3="IA","6%",IF(H3="IC","6%",IF(H3="IR","6%",IF(H3="HR","6%",IF(H3="IL","0%",IF(H3="IN","0%",IF(H3="IO","0%",IF(H3="IS","0%",IF(H3="IX","0%",IF(H3="OO","0%",IF(H3="OX","0%")))))))))))))))))))) "