SMALL & LARGE functions

The SMALL function returns the k-th smallest number from an array of numbers. The SMALL function syntax is as follows: = SMALL ( array; k ) Array can be any row, column, or a combination of both. k is an integer number representing the position of a number in the array if data in that array would be sorted from the smallest.   Consider the following example: If k is 1, the smallest number will be returned. If k is

Numbers in Excel

How are numbers stored, formatted and calculated? When dealing with numbers in Excel we should be aware of a few things: numbers in Excel can be formatted in many ways: plain numbers, currency, percentage, date etc. no matter how they are formatted and possibly edited, underlying values saved in cells are still decimal numbers those decimal numbers that Excel uses and calculates with go up to 15 decimal places (and even with that, there are caveats) this is not changed