One of the basic usage of Excel is performing simple calculations. This is the first step to perform complex analysis using Excel. Below is an example of each of the elementary operator usage.
Addition:
Lets take an example, where you have two numbers, each one in separate cell, and you want to store the addition result in the third cell
In the below example, the sum of cell A2 and A3 will be stored in cell A4.
Go to cell A4 and type =A2+A3
And press 'Enter'
Multiplication:
You will have to type =A2*A3 in cell A4
Division:
Type =A2/A3 in cell A4.
Exponential:
Type =A2^A3 in cell A4. Character ^ is Shift+6 on most keyboards.
Addition:
Lets take an example, where you have two numbers, each one in separate cell, and you want to store the addition result in the third cell
In the below example, the sum of cell A2 and A3 will be stored in cell A4.
Go to cell A4 and type =A2+A3
Subtraction:
In the similar fashion, if you type =A2-A3 and press Enter, you will see the following result
You will have to type =A2*A3 in cell A4
Type =A2/A3 in cell A4.
Exponential:
Type =A2^A3 in cell A4. Character ^ is Shift+6 on most keyboards.
0 comments:
Post a Comment