Excellent... thank you... _____
From: Paul Wilson [mailto:[email protected]] Sent: Tuesday, July 20, 2010 7:56 AM To: [email protected] Subject: Re: Witango-Talk: Sum of Square Root 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 ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
