We will study Complex Numbers in Google Sheets today. Google Sheets is specifically designed for performing calculations, including the writing of complex numbers and equations. Thus, inserting a complex number in Google Sheets is now quite simple. Complex numbers are expressed as (a + bi), where a, b, and i are real and imaginary numbers, respectively. The letter “j” can also be used to represent complex numbers. Let’s get started with the next tutorial, where we will go into great detail about complex numbers in Google Sheets today.
Uses of Complex Numbers in Google Sheets?
Because complex numbers have applications across many fields of mathematics and physics, they could be necessary for you to use in Google Sheets as a math and physics student. Equations can be written using them in Google Sheets. Here is a step-by-step tutorial to help you build a complex number in Google Sheets if you still need to learn how.
You may also like>>> How To Create An Invoice Template In Google Sheets [FREE Template]
Complex Numbers in Google Sheets – Step-by-Step Procedure
Just two kinds of complex integers can be written with the letter “i” or the letter “j” and are utilized in Google Sheets. We will learn how to handle both Complex numbers in this Google Sheets tutorial on Complex numbers. To differentiate between these Complex numbers, you simply need to provide their suffix symbols, even though their methods are the same. Let me show you in detail in the following step-by-step method.
- Complex numbers in Google Sheets
- Complex numbers in Google Sheets with Suffix
Complex numbers in Google Sheets
Since Google Sheets released the ability to create complex numbers, producing a complex number in Google Sheets has become incredibly simple. The following methods will assist you in creating a complicated number in Google Sheets with ease.
Step 1>
Assume for the moment that we have a cell where we must use the following real numbers to construct a complex number. Let’s see how to use Google Sheets to generate a complex number.
Step 2>
As previously discussed, Google Sheets has an integrated function for creating complex numbers. To start the function, simply write “COMPLEX” followed by an equal sign, as I have done below.
Step 3>
We have provided the cell reference for the values here because, once the function is started, we will need to specify the real numbers in the syntax that is provided below.
Step 4>
Simply enter the cell reference of the values you wish to build a complex number from, as shown in the following image, then hit the Enter key to obtain your complex number.
Step 5>
You can also write the numbers into your cell’s syntax like I’ve done in the example below if the values aren’t already placed there. You will obtain the identical result as before in this way as well.
It is not required to write “i” if you are constructing a complex number with “i“; Google Sheets automatically generates a complex number with “i“.
Complex numbers in Google Sheets with Suffix
A complex number can have only two kinds of suffixes, indicated by the letters “i” or “j.” It will write the complex number with “i” by default if you don’t give the suffix; however, you must express it in the syntax if you wish to write the complex number with “j.” Let me show you the steps that follow.
Step 1>
We will use Suffix to convert two real numbers in the sample data table below into a complex number. Let’s look at how to construct a complex number with respect to Suffix.
Step 2>
Run the Complex function in the same way as described earlier by entering “COMPLEX” in the cell with an equal sign and giving the cell address of the values for which we are generating a complex number with a suffix.
Step 3>
If the suffix symbol “j” is not specified in the syntax, the COMPLEX function will produce a complex number with an iota if the suffix is not specified. To avoid this, you can specify the suffix symbol “j” as I have done in the below image.
Step 4>
Now, if you hit the Enter key, the complex number with the given values and the letter “j” will appear as the result below.
You may also like>>> How To Make A Ledger Template In Google Sheets – [Free Template]
FAQs – Complex Numbers in Google Sheets
How to solve Complex numbers in Google Sheets?
A number with both real and imaginary components is called a complex number. The steps below can be used to determine the imaginary portion of the Complex number in Google Sheets.
Step 1>
The complex integer in the table of the example data below that contains the letter “i” represents the imaginary component of the equation. Let’s investigate how to locate this imaginary part of the equation using Google Sheets.
Step 2>
Google Sheets has an integrated function called “IMAGINARY” that can be used to identify the imaginary part of an equation. In this case, we will use Google Sheets’ IMAGINARY function in the cell and supply the Complex number’s cell reference, provided below.
Step 3>
There is nothing more to do; all you have to do is hit the Enter key to obtain the result. As I have shown below, this will give you the imaginary part of the Complex number.
How to add Complex numbers in Google Sheets?
Adding a few complex integers doesn’t need you to evaluate them by hand; the assist function makes it simple to accomplish. The instructions to add complex integers to Google Sheets are listed below.
Step 1>
In the sample data below, we have two separate complex numbers that we wish to combine together. Let’s examine how we can use Google Sheets’ IMSUM feature to add them.
Step 2>
To get started, select the cell where you wish to view the results and launch Google Sheets’ IMSUM function by following the steps I’ve listed below.
Step 3>
Give the cell references for both Complex numbers in the syntax after the function has started. These cell references will be separated by commas as seen in the pattern below.
Step 4>
To get the result I’ve got in the following example, just type the syntax and hit the Enter key. You can now confirm the solution mathematically by adding the two complex numbers; the result will be the same.
You can add complex numbers to Google Sheets in an easy way like this.
How to square Complex numbers in Google Sheets?
It is usual practice to square complex numbers in equations. If you need to square a complex number in Google Sheets, you can use the following procedures to figure out the square of any complex integer in Google Sheets directly.
Step 1>
As you can see in the image below, there is a complicated number written in cell B3 that we need to find the square of in Google Sheets. See if we can locate it together.
Step 2>
We will use the “IMPOWER” built-in function in Google Sheets to find the square of a complex number. Just run the function and enter the complex number’s reference as shown below.
Step 3>
We must indicate the power of the coefficient after providing the cell reference of a complex number. Since we are determining the complex number’s square, we will write the power “2” in this case.
Step 4>
Simply hit the Enter key after finishing the syntax to obtain the square of the specified complex integer, as shown in the following image.
Conclusion
That’s all there is to know about the complex number in Google Sheets; perhaps, the knowledge you’ve been given will be useful. For more keep learning with Office Chaser.