i trying make form has these formulas calculations each entry. how make new entries?
=if(and(e2="stfyc",g2<41),g2*0.49,if(and(e2="stfyc",and(g2>40,g2<71)),g2*0.65,if(and(e2="stfyc",and(g2>70,g2<101)),g2*0.77,if(and(e2="stfyc",100<g2),0.94*g2,if(and(e2<>"stfyc",g2<41),g2*1.2,if(and(e2<>"stfyc",and(g2>40,g2<71)),1.45*g2,if(and(e2<>"stfyc",and(g2>70,g2<101)),g2*1.8,if(and(e2<>"stfyc",100<g2),2.1*g2)))))))) =if(h2="30a",0,if(h2="2x30a",17,if(h2="50a",17,if(h2="2x50a",30,if(h2="100a",30,""))))) =if(n2="","",n2-l2) =if(o2="","",(j2+k2)*o2)
you need use special formula "arrayformula" allow set formula on first row of document , repeated beneth rows.
here exemple formula =if(n2="","",n2-l2)
array formula like: =arrayformula(if(n2:n="","",n2:n-l2:l))
first 2 formulas gave bit more complicated encapsulate in arrayformula (try use named range that)
Comments
Post a Comment