Excuse me, I meant the sum of the squares I believe it is the sum of the squares. For example SUMSQ(2,3,4) = 29 (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29
It may be a simple as breaking up Excel's fancy SUMSQ into a formula. sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e On Tue, Jul 20, 2010 at 8:54 AM, Paul Wilson <[email protected]> wrote: > I believe it is the sum of the square roots. For example SUMSQ(2,3,4) = 29 > (2*2) + (3*3) + (4*4) = 4 + 9 + 16 = 29 > > It may be a simple as breaking up Excel's fancy SUMSQ into a formula. > sqrt( ((b1-b2)*(b1-b2)) + ((c1-c2)*(c1-c2)) + ((d1-d2)*(d1-d2)) ) = e > > > > On Tue, Jul 20, 2010 at 8:31 AM, WebDude <[email protected]> wrote: > >> I was given an excel file that needs to be converted to a web page. I am >> not a Math guru and was wondering if someone could help me out. >> >> The form has some fields with a formula that looks like this (cell e is >> the result)... >> >> =SQRT(SUMSQ(b1-b2,c1-c2,d1-d2)) --- This is the formula for cell e >> >> b c d e >> Reference: 0.00 Sample Measurement: >> >> All 6 yellow cells will be inputs. What I don't get is how to sum a square >> root. Any help would be appreciated. >> >> Thanks! >> >> p.s. I hope the format of this email doesn't fall apart. >> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >> >> > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
