AVERAGE function is used to get the average of numbers. Function applies formula i.e. average = Sum of all values / (Divided by) number of items
AVERAGE Function has one required argument i.e. number1, and optional argument i.e. [number2].
=AVERAGE(number1,[number2],...)
number1 argument is used to number value/cell reference/range for which average is required
[number2] argument is used to another number value value/cell reference/range
… means, we can add multiple value/cell reference/range by separating them with comma ( , )
Don’t forget to leave your valuable comments!
If you liked this article and want to learn more similar tricks, please Subscribe us or follow us on Social Media by clicking below buttons:
You must have faced a condition when your data cells contain extra spaces, leading spaces or trailing spaces and you wanted to remove these extra spaces to standardize the data. So here you may use…
MID function is used for extracting the mid characters from the available string. The output of the function returns the extracted characters in new cell.
LEFT function is used for extracting the “Left Most” characters from the available string. The output of the function returns the extracted characters in new cell
Excel Function- WORKDAY.INTL WORKDAY.INTL function is an advanced version of WORKDAY function with additional advantage of “Custom weekend options” For Example, with WORKDAY function weekends are treated as “Saturday and Sundays” however if you need…
UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.
Microsoft Excel “TODAY” function is used to get the current Date. It is very useful function and can be used in many ways. “TODAY Function” does not have any argument that makes this easy to apply and implement.