Converting from Lotus 123 to Excel Missing functions
When converting from 123 not all functions in 123 are available
to Excel users. One of these surprisingly is Weighted Average (WeightedAve) in
order to deal with this problem the easiest way is to define your own function
like the one below:
Public Function WeightedAve(Array1 As
Range, Array2 As Range)
Application.Volatile
WeightedAve =
Application.WorksheetFunction.SumProduct(Array1, Array2) /
Application.WorksheetFunction.Sum(Array2)
End Function |
|
