Excel's PERCENTOF function returns the percentage that a subset of data contributes to a whole dataset, saving you from having to create additional or complex formulas to generate the same outcome ...

Using data in Column C, calculate the daily percentage change in the index. Starting with cell D4, the formula is the current day's closing value divided by the previous day's closing value minus ...