On many of these measures, investment supermarket Hargreaves Lansdown is the most profitable company in the FTSE 350. Last year it generated revenues of Â£358 million, of which 45 per cent (Â£162 million) ended up as net profit.
Rand Function Examples. In the following spreadsheet, the Excel Rand function is used to generate random numbers between different limits. Note that the above formulas will return a different random number every time the spreadsheet recalculates. To force a recalculation at any time, press the F9 key. For further details of the Excel Rand Function, see the Microsoft Office website.
The Microsoft Excel MIN function returns the smallest number in a list of arguments. If the smallest number is zero (0), the function returns zero. To return the smallest number greater than zero, enter the following array formula. where A1:A10 represents the range of the numbers. This returns an array of a single value with the smallest positive number. NOTE: To enter an array formula in Excel for the Macintosh, press COMMAND+RETURN.