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.

Learn what IRR is, how it's calculated, its uses in investment analysis, and factors to consider when interpreting it.