Excel Function : T.INV
Category
Statistical
Description
Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom
Microsoft Excel Reference Page
https://support.office.com/en-us/article/TINV-function-2908272b-4e61-4942-9df9-a25fec9b0e2e
Syntax and Description of the T.INV Excel Function
if (cellValue.contains("T.INV")) { //remove syntax T.INV cellValue = cellValue.replace("T.INV", ""); //get syntax of excel function cellValue = cellValue.substring(cellValue.indexOf("(")+1, cellValue.lastIndexOf(")")); //replace - by `- cellValue = cellValue.replace("-", "`-"); //replace DEC by DECIMAL
About T.INV Excel Function
T.INV returns the t-value for the given probability and degrees of freedom.
