How can I make these formulas work with google forms so they reproduce into new entries? -


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