Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic System Error-Userform | Excel Discussion (Misc queries) | |||
Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Visual Basic Help | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |