Users of Microsoft’s flagship 2D-array-based data-organisation tool Excel will be aware of some if its more recondite functions. From the occasionally useful
RIGHT: returns the substring of a given length from the right-hand end of a cell’s contents
to the wilfully obscure
TBILLPRICE: gives “the price per $100 face value for a Treasury bill” when supplied with its settlement date, maturity date and discount rate
to the downright cryptic
N: obviously, converts its argument to a numeric format if it can
along with approximately 340 others, Excel’s abilities are near limitless.
But one function seems singular in the sheer decadence of its inclusion.