Create a udf for weighted average

  • These are the conditions :

    If the 2 parameters do not have the same size, it will return the text string “incorrect parameter size”.

    If one value in the first parameter is not a number, it will be omitted (no error message AND no impact on

    the final result).

    If one value in the second parameter is not a number, the function returns the error message “invalid

    coefficient”


    This is my code and it's not working


    Edited once, last by Carim: Added Code Tags ().

  • Hello and Welcome to the Forum :)


    There are several possibilities offered by Excel for weighted averages ...


    Best thing to do is to attach a sample file ... to illustrate your expected result ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)