What are the commonly used mathematical functions in Excel?

#What are the commonly used mathematical functions in excel?

Today we will talk about the most commonly used mathematical functions in Excel, such as rounding, absolute value, rounding up and down, etc.

Round function

The main function of this function is rounding. When the specified parameter is 0, rounding is performed.

Int function

The main function of this function is to return the largest integer that is less than or equal to the parameter.

Trunc function

The main function of this function is to truncate a number to an integer or retain a specified number of decimal places. The obvious difference from the INT function is that it can retain a specified number of decimal places.

RoundUp function

Rounds the value up by the specified number of digits. The obvious difference from the Trunc function is that this function rounds the value upward by the specified number of digits.

ABS function

The main function of this function is to return the absolute value of a given value, such as converting all values ​​through a formula It is an integer and 0.

Mod function

This function is mainly used to calculate the remainder after dividing two numbers.

The following formula can determine whether the value of cell A1 is odd or even:

=IF(MOD(A1,2),"奇数","偶数")

The following formula can determine whether the A1 ID number is male or female:

=IF(MOD(MID(A1,17,1),2),"男","女")

Copy the following formula Fill to A2:A500, you can generate serial numbers of 123~123~123... in a loop:

=MOD(ROW(A3),3)+1

For more EXCEL related tutorials, please visit the excel basic tutorial column!

The above is the detailed content of What are the commonly used mathematical functions in Excel?. For more information, please follow other related articles on the PHP Chinese website!