Functions are convenient functions of Excel. It can be said to be the basics of Excel with everything from basic functions such as addition, subtraction, multiplication, and division to complex and powerful functions.
The function consists of the function_name(argument), and the result is displayed in the cell where the function formula is entered. The usage is the same for any other function.
=SUM(A2:I2) means as below.
|SUM||Find the sum of the factors.|
|A2:I2||This is the range of cells (from cells A2 to I2).|
Arithmetic operators that can be used in Excel are as follows.
|=A2+B2||Add cell A2 and cell B2|
|=A2-B2||Subtract cell B2 from cell A2|
|=A2*B2||Multiply cell A2 by cell B2|
|=A2/B2||Divide cell A2 into cell B2|
|=A2^B2||Cell A2 to the power of B2|
|=A2*B2%||Finding B2 Percent of Cell A2|
It is also possible to use a combination of the arithmetic operators described above.
As you learned in math class, you start with the parentheses ().
Comparison operators that can be used in Excel are as follows.
|=A2>B2||A2 is greater than B2|
|=A2||A2 is less than B2|
|=A2=B2||A2 equals B2|
|=A2>=B2||A2 is greater than or equal to B2|
|=A2<=B2||A2 is less than or equal to B2|
|=A2<>B2||A2 is different from B2|
In addition to numbers, you can also enter regular characters.
(You can see that large and small are determined according to the order of the letters)