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.
Parameter list: Usage notes: Use the RAND function to get a random number between 0 and 1. For example, =RAND() will generate a number like 0.422245717. To get a random number that doesn't change when the worksheet is calculated, enter =RAND() in the formulas bar and then press F9 to convert the formula into its result.