Formula in Visual Basic For Excel
 

Hello,
This is my problem :
How can I calculate with Visual Basic For Excel the result of the following
function :
X = (a1 - ma)^2 + (a2 - ma)^2 + ... + (aN - ma)^2
1,2, ...,N are indexes
N is known
ma is the average of the different notes(a1,a2,...,aN) and is fixed.
X is the result I search.
The value of a1,... is not fixed and evoluate in conjunction with the
indexes.

How can I do to find the result. Must I use a personalized function ?

Thank you in advance,


Jean-michel

Jean-michel,

Are a1, a2 ... cell references or are they a product of... a * 1, a * 2,... a * n ?

Regards,
Jim Cone
San Francisco, CA

"imej-clavier" wrote in message
...
Hello,
This is my problem :
How can I calculate with Visual Basic For Excel the result of the following
function :
X = (a1 - ma)^2 + (a2 - ma)^2 + ... + (aN - ma)^2
1,2, ...,N are indexes
N is known
ma is the average of the different notes(a1,a2,...,aN) and is fixed.
X is the result I search.
The value of a1,... is not fixed and evoluate in conjunction with the
indexes.
How can I do to find the result. Must I use a personalized function ?
Thank you in advance,
Jean-michel

You can call the worksheet function DEVSQ from VBA as
Application.DevSq()
in all Excel versions that support VBA, or as
WorksheetFunction.DevSq()
in Excel 97 or later. The WorksheetFunction. prefix will pull up a list
of worksheet functions that are supported in VBA.

Jerry

imej-clavier wrote:

Hello,
This is my problem :
How can I calculate with Visual Basic For Excel the result of the following
function :
X = (a1 - ma)^2 + (a2 - ma)^2 + ... + (aN - ma)^2
1,2, ...,N are indexes
N is known
ma is the average of the different notes(a1,a2,...,aN) and is fixed.
X is the result I search.
The value of a1,... is not fixed and evoluate in conjunction with the
indexes.

How can I do to find the result. Must I use a personalized function ?

Thank you in advance,


Jean-michel