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.
