Syntax :

=AVEDEV(number1, [number2],…)

Patrameters :

where the number parameters are one or more numeric values (or arrays of numeric values) whose average deviation you wish to find. You may pass up to 255 number parameters to the Avedev function if you’re using a current version of Excel (Excel 2007 or later). In Excel 2003, however, the function can only accept up to 30 number parameters. arguments.

 It should be noted that logical values and text values (including text representations of integers) are ignored by the Avedev function if they are given as part of an array. The function, on the other hand, counts text representations of numbers and logical values that are sent directly to it as individual number arguments.