I want to insert long formula to destination Excel in rows T9. I tried to use invoke VBA to direct insert or copy formula from source Excel to the destination but nothing worked. If i use UiPath read range it only copy the value (COMPLY) not the formula. The formula is :
=IF(AND(I9=“Normal”;O9>4;O9<7;L9=“NRM”);“NOT OK”;IF(OR(AND(F9=“Foreman”;I9=“Holiday”;L9=“NRM”;O9>=8;L10=“NRM”);AND(F9=“Foreman”;I9=“Joint holiday”;L9=“NRM”;O9>=8;L10=“NRM”);AND(F9=“Assistant Foreman”;I9=“Holiday”;L9=“NRM”;O9>=8;L10=“NRM”);AND(F9=“Assistant Foreman”;I9=“Joint holiday”;L9=“NRM”;O9>=8;L10=“NRM”));“NOT OK”;IF(OR(AND(D9=“General Administration (A-MJK)”;I9=“Holiday”;L9=“NRM”;O9>=7;L10=“NRM”);AND(D9=“General Administration (A-MJK)”;I9=“Joint holiday”;L9=“NRM”;O9>=7;L10=“NRM”);AND(D9=“Production Planning & Iventory Control (A-MJK)”;I9=“Holiday”;L9=“NRM”;O9>=7;L10=“NRM”);AND(D9=“Production Planning & Iventory Control (A-MJK)”;I9=“Joint holiday”;L9=“NRM”;O9>=7;L10=“NRM”);AND(D9=“QSE (A-MJK)”;I9=“Holiday”;L9=“NRM”;O9>=7;L10=“NRM”);AND(D9=“QSE (A-MJK)”;I9=“Joint holiday”;L9=“NRM”;O9>=7;L10=“NRM”);AND(E9=“Engineering & Maintenance (A-MJK)”;I9=“Holiday”;L9=“NRM”;O9>=7;L10=“NRM”);AND(E9=“Engineering & Maintenance (A-MJK)”;I9=“Joint holiday”;L9=“NRM”;O9>=7;L10=“NRM”);AND(E9=“ITEC Project (NEX-MJK)”;I9=“Holiday”;L9=“NRM”;O9>=7;L10=“NRM”);AND(E9=“ITEC Project (NEX-MJK)”;I9=“Joint holiday”;L9=“NRM”;O9>=7;L10=“NRM”);AND(E9=“Quality Assurance (NEX-MJK)”;I9=“Holiday”;L9=“NRM”;O9>=7;L10=“NRM”);AND(E9=“Quality Assurance (NEX-MJK)”;I9=“Joint holiday”;L9=“NRM”;O9>=7;L10=“NRM”));“NOT OK”;IF(AND(I9=“Off”;K9=“S0700-1600”;L9=“NRM”;O9>=8;L10=“NRM”);“NOT OK”;IF(AND(I9=“Off”;K9=“S0700-1500”;L9=“NRM”;O9>=7;L10=“NRM”);“NOT OK”;IF(AND(I9=“Off”;K9=“S1500-2300”;L9=“NRM”;O9>=7;L10=“NRM”);“NOT OK”;IF(AND(I9=“Off”;K9=“S2300-0700”;L9=“NRM”;O9>=7;L10=“NRM”);“NOT OK”;IF(AND(I9=“Normal”;L9=“NRM”;O9>=7;L10=“NRM”);“NOT SAFETY”;“COMPLY”))))))))