How to Use Excel's TDIST Function

Enter in the numeric values you need to compare in the appropriate cells. For this example, enter the number 9 in cell A2 and 10 in cell A3.

Use your cursor to click on the cell where you want the results of the comparisons to be displayed. Type in the Excel formula exactly as follows: =TDIST(A2,A3,1).

Move the mouse cursor anywhere else on the spreadsheet and left-click. The result of the formula will be displayed in cell where you entered the formula, which is 2.06902E-06.

Display the result of the TDIST formula as a percentage by placing your cursor on the cell showing the formula and right-clicking. Select the option "Format Cells" from the menu. This will open a new window. Choose "Percentage" and then click "Ok." The number will now show as a percentage, in this instance, 0.00.