Ping?
From: WebDude [mailto:webd...@cipromo.com]
Sent: Thursday, July 22, 2010 10:49 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Sum of Square Root
Excellent... thank you...
_
From: Paul Wilson [mailto:pwilson@gmail.com]
Sent: Tuesday, July 20, 2010 7:56 AM
pong
_
From: Robert Shubert [mailto:rshub...@tronics.com]
Sent: Monday, August 02, 2010 12:02 PM
To: Witango-Talk@witango.com
Subject: RE: Witango-Talk: Sum of Square Root
Ping?
From: WebDude [mailto:webd...@cipromo.com]
Sent: Thursday, July 22, 2010 10:49 AM
To: witango-talk
, July 22, 2010 10:49 AM
To: witango-talk@witango.com
Subject: RE: Witango-Talk: Sum of Square Root
Excellent... thank you...
From: Paul Wilson [mailto:pwilson@gmail.com]
Sent: Tuesday, July 20, 2010 7:56 AM
To: witango-talk@witango.com
Subject: Re: Witango-Talk: Sum of Square Root
Excellent... thank you...
_
From: Paul Wilson [mailto:pwilson@gmail.com]
Sent: Tuesday, July 20, 2010 7:56 AM
To: witango-talk@witango.com
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
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
From: WebDude [mailto:webd...@cipromo.com]
Sent: Tuesday, July 20, 2010 9:32 AM
To: witango-talk@witango.com
Subject: Witango-Talk: Sum of Square Root
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
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,
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
