![]() ![]() However, cells with the value zero are included. If a range or cell reference argument contains text, logical values, or empty cells, those values are ignored.The AVERAGE function ignores empty cells.As the function can automatically handle array results, we don’t need not use Ctrl+Shift+Enter to enter the formula. Later, the AVERAGE function returned the average of the values. So, we got the top 3 values as we used the array constant into LARGE for the second argument. ![]() In the above formula, the LARGE function retrieved the top nth values from a set of values. We wish to find out the top 3 scores in the above data set. To understand the uses of the AVERAGE function, let us consider a few examples: ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |