| | | If any of the arguments are not numeric, then #VALUE! is returned. |
| | | If "probability" < 0, then #NUM! is returned. |
| | | If "probability" > 1, then #NUM! is returned. |
| | | If "degrees_freedom" is not an integer, it is truncated. |
| | | If "degrees_freedom" < 1, then #NUM! is returned. |
| | | If "degrees_freedom" = 10^10, then #NUM! is returned. |
| | | This function uses an iterative technique for calculating the result. |
| | | This function iterates until the result is accurate to within ± 3x10^-7. |
| | | If the iterative process does not converge after 100 iterations, then #N/A is returned. |
| | | The accuracy of this function was improved in Excel 2003. For more information please refer to this Knowledge Base Article (828313). |