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
