Results 1 to 5 of 5

Thread: arguments in functions

  1. #1

    Red face arguments in functions

    Register for a FREE account, and/
    or Log in to avoid these ads!

    = Average (number1, number2...)
    = AverageAll(value1, value2...)

    in the first function excel ask for numbers as arguments
    in the second ask for values as arguments
    what is the difference between number and values in this case? the arguments of second function are numbers too and why the sintax is not =AverageAll(number1, number2...)
    I hope to be clear, my english is very very bad...

  2. #2
    Admin Alumnus Pecoflyer's Avatar
    Join Date
    Oct 2011
    Brussels Belgium
    Excel Version
    2010 on Xubuntu
    In which application do you use AverageAll ? It's not native to Excel

  3. #3
    in Excel
    sorry! name function is Averagea

  4. #4

  5. #5
    Maybe I have not explained well. My question is not about the functions, there are just for example. I'm not clear about their actual arguments. Why Excel, for some functions ask to specify NUMBERS, and for other ask to specify VALUES, when all these functions use NUMERICAL VALUES. What does mean VALUE in these functions? That they can use not only numerical values, but other values like text and logical?
    Anyway thank you for replyes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts