sheet.setFormula(i, 11, '=PRODUCT(E'+(i+1)+',H'+(i+1)+',K'+(i+1)+')');
sheet.setFormula(i, 12, '=IF(ISNUMBER(L'+(i+1)+'),VLOOKUP(H'+(i+1)+',\'Risk Matrix\'!$A$2 K$11,E'+(i+1)+'+1,FALSE),"")');
sheet.setFormula(i, 13, '=IF(ISNUMBER(L'+(i+1)+'),VLOOKUP(K'+(i+1)+',\'Risk Matrix\'!$A$22 K$31,E'+(i+1)+'+1,FALSE),"")');
sheet.setFormula(i, 14, '=IF(ISNUMBER(L'+(i+1)+'),VLOOKUP(N'+(i+1)+',\'Risk Matrix\'!$A$42 D$44,M'+(i+1)+'+1,FALSE),"")');
sheet.setFormula(i, 22, '=PRODUCT(T'+(i+1)+',U'+(i+1)+',V'+(i+1)+')');
sheet.setFormula(i, 23, '=IF(ISNUMBER(L'+(i+1)+'),VLOOKUP(U'+(i+1)+',\'Risk Matrix\'!$A$2 K$11,T'+(i+1)+'+1,FALSE),"")');
sheet.setFormula(i, 24, '=IF(ISNUMBER(L'+(i+1)+'),VLOOKUP(V'+(i+1)+',\'Risk Matrix\'!$A$22 K$31,U'+(i+1)+'+1,FALSE),"")');
sheet.setFormula(i, 25, '=IF(ISNUMBER(L'+(i+1)+'),VLOOKUP(Y'+(i+1)+',\'Risk Matrix\'!$A$42 D$44,X'+(i+1)+'+1,FALSE),"")'); |