Table of Contents
The ERFC function in Google Sheets is a mathematical function that calculates the complementary error function of a given value. This function is useful in statistics, probability, and other scientific calculations. To use the ERFC function in Google Sheets, simply enter the function name followed by the value or cell reference within parentheses. The result will be displayed in the cell where the formula is entered. This function can also be used in conjunction with other functions to perform more complex calculations. It is important to note that the ERFC function is case sensitive and any errors in the input may result in an incorrect output.
ERFC
The ERFC function returns the complementary Gauss error function of a value.
Sample Usage
ERFC(2)
ERFC(A2)
Syntax
ERFC(z)
z– The number for which to calculate the complementary Gauss error function.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdFhHZUpZejZ3RW5OVVFtZXQ5NGQ3TFE&output=html” width=”500″]
Cite this article
stats writer (2024). How do I use the ERFC function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-erfc-function-in-google-sheets/
stats writer. "How do I use the ERFC function in Google Sheets?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-erfc-function-in-google-sheets/.
stats writer. "How do I use the ERFC function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-erfc-function-in-google-sheets/.
stats writer (2024) 'How do I use the ERFC function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-erfc-function-in-google-sheets/.
[1] stats writer, "How do I use the ERFC function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use the ERFC function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.