![]() ![]() The bonus amounts are in cells C2:C9, and this formula is in cell E5: In this example, there are eight employee bonus amounts in the list - an even number of values. There is an odd number of values in the data set, so MEDIAN returns the number in the middle of the data set - 1500. The bonus amounts are numeric values, in cells C2:C8, and the following formula is in cell E5: Note: The list is sorted by bonus amounts, largest to smallest, but that is not necessary. In this example, there is a small list of seven employee ID numbers, and their annual bonus payment for the current year. You can type numbers into the formula, or use a cell reference, or refer to a large range of cells on the spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |