Percentile Exc function will return k-th Percentile of values in a range, where k is 0 to 1. Learn how to use Percentile.Exc in Excel.

Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does.

If you need to conditionally split values into multiple columns in Microsoft Excel, consider using the IF() function. Here's how.