Formula Help

D33P
Administrator

Posts: 513

Formula Help Jul 28, 2015 1:40:19 GMT -5

Quote

Post by D33P on Jul 28, 2015 1:40:19 GMT -5

I've been trying to make a new formula for Fork stats, but Google spreadsheets keeps on giving me a formula error. Please look for any mistakes (mostly syntax) in the following forumula:

=SUM(=DIVIDE(=MULTIPLY(C2,1),B2),
=SUM(=DIVIDE(=MULTIPLY(D2,.5),B2),
=SUM(=DIVIDE(=MULTIPLY(E2,.25),B2),
=SUM(=DIVIDE(=MULTIPLY(G2,.2),B2),
=SUM(=DIVIDE(=MULTIPLY(H2,.05),B2),
=SUM(=DIVIDE(=MULTIPLY(I2,.4),B2),
=SUM(=DIVIDE(=MULTIPLY(J2,.1),B2),
=SUM(=DIVIDE(=MULTIPLY(K2,.5),B2),
=SUM(=DIVIDE(=MULTIPLY(L2,.25),B2),=DIVIDE(=MINUS(=DIVIDE(N2,M2),.5),1))))))))))

Last Edit: Jul 28, 2015 1:40:47 GMT -5 by D33P

D33P Administrator Posts: 513	Formula Help Jul 28, 2015 1:53:52 GMT -5 Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by D33P on Jul 28, 2015 1:53:52 GMT -5 nvm just turned out it doesnt like other formulas inside of formulas

Magi FTL Posts: 90	Formula Help Jul 28, 2015 16:34:49 GMT -5 Quote Select Post Deselect Post Link to Post Member Give Gift Back to Top Post by Magi on Jul 28, 2015 16:34:49 GMT -5 It must be aformula
	Last Edit: Jul 28, 2015 16:34:53 GMT -5 by Magi

Post by D33P on Jul 28, 2015 1:40:19 GMT -5

Post by D33P on Jul 28, 2015 1:53:52 GMT -5

Post by Magi on Jul 28, 2015 16:34:49 GMT -5