﻿ F.INV.RT | Spread Formula Reference
Formula Functions / Functions D to G / F.INV.RT
In This Topic
F.INV.RT
In This Topic

This function returns the inverse of the F probability distribution.

#### Syntax

F.INV.RT(p,degnum,degden)

#### Arguments

This function has these arguments:

Argument Description
p Probability associated with the F cumulative distribution
degnum Number of degrees of freedom for the numerator; if not an integer, the number is truncated
degden Number of degrees of freedom for the denominator; if not an integer, the number is truncated

#### Remarks

This function calculates the inverse of the F probability distribution, so if p = FDIST.RT(x,...), then FINV.RT(p,...) = x. The #VALUE! error value is returned if any argument is nonnumeric.

#### Data Types

Accepts numeric data for all arguments. Returns numeric data.

#### Examples

F.INV.RT(A1,2,2)

F.INV.RT(R1C1,2,1)

F.INV.RT(0.021,5,3) gives the result 16.83979663538795

#### Version Available

This function is available in Spread for Windows Forms 11.0 or later.