Table of Contents
The IMEXP function in Google Sheets is a powerful tool that allows users to calculate the exponential value of a complex number. This function follows the standard mathematical format of inputting the real and imaginary parts of a number and returns the exponential value in the form of a complex number. To use the IMEXP function, simply input the desired complex number as the function’s argument and press enter. This function is useful for various mathematical and engineering calculations, making it a valuable tool for users of Google Sheets.
IMEXP function
The IMEXP function returns Euler’s number, e (~2.718) raised to a complex power.
Parts of a IMEXP function
IMEXP(exponent)
| Part | Description |
|---|---|
exponent | The exponent to raise e to. |
Sample formulas
IMEXP("2+3i")
IMEXP("2-4j")
IMEXP(COMPLEX(2, 3))
Notes
- The exponential of a complex number is defined as follows:
IMEXP(x+yi) = excos(y) + iexsin(y)
Examples
| A | B | |
|---|---|---|
| 1 | Formula | Result |
| 2 | =IMEXP(“1+i”) | 1.46869393991589+2.28735528717884i |
| 3 | =IMEXP(“2-2j”) | -3.07493232063936-6.71884969742825j |
Related functions
- EXP: Returns Euler’s number, e (~2.718) raised to a power.
- IMLN: The
IMLNfunction returns the logarithm of a complex number, base e (Euler’s number). - COMPLEX: The COMPLEX function creates a complex number, given real and imaginary coefficients.
- IMAGINARY: Returns the imaginary coefficient of a complex number.
Cite this article
stats writer (2024). How can I use the IMEXP function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-imexp-function-in-google-sheets/
stats writer. "How can I use the IMEXP function in Google Sheets?." PSYCHOLOGICAL SCALES, 29 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-imexp-function-in-google-sheets/.
stats writer. "How can I use the IMEXP function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-imexp-function-in-google-sheets/.
stats writer (2024) 'How can I use the IMEXP function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-imexp-function-in-google-sheets/.
[1] stats writer, "How can I use the IMEXP function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the IMEXP function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.