Excel Function : TINV

Download now!

Excel Function : TINV

Category

Compatibility

Description

Returns the inverse of the Student's t-distribution

Microsoft Excel Reference Page

https://support.office.com/en-us/article/TINV-function-a7c85b9d-90f5-41fe-9ca5-1cd2f3e1ed7c

Syntax and Description of the TINV Excel Function

if else error I have a function that needs to return a true or false value. If the value is greater than 1,000,000 it needs to return true, else it needs to return false. If the value is empty it should return false. =IF(A1>1000000,TRUE,FALSE) However, if the value is empty, I get a #VALUE! error. How do I get the function to return false if the cell is empty? A: You may use: =IF(A1>1000000,TRUE,FALSE)

About TINV Excel Function

The TINV function returns the inverse of the Student's t-distribution.