RAND () Function Excel uses the function RAND () to return a random and uniformly distributed number between 0 and 1, every time the worksheet is calculated.

You can subtract numbers in Microsoft Excel in a few different ways, depending on your data and formatting.