microsoft-office

Excel: How to use functions

This post is also available in: 한국어 (Korean) English 日本語 (Japanese)

1_Function basics

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.

SUMFind the sum of the factors.
A2:I2This is the range of cells (from cells A2 to I2).

2_arithmetic operator

Arithmetic operators that can be used in Excel are as follows.

=A2+B2Add cell A2 and cell B2
=A2-B2Subtract cell B2 from cell A2
=A2*B2Multiply cell A2 by cell B2
=A2/B2Divide cell A2 into cell B2
=A2^B2Cell 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 ().

3_comparison operator

Comparison operators that can be used in Excel are as follows.

=A2>B2A2 is greater than B2
=A2A2 is less than B2
=A2=B2A2 equals B2
=A2>=B2A2 is greater than or equal to B2
=A2<=B2A2 is less than or equal to B2
=A2<>B2A2 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)

This post is also available in: 한국어 (Korean) English 日本語 (Japanese)

Archives

Recent Comments