Introduction to Excel Common functions (4)

Today we continue with the following seven common functions:

MoD function: Find the remainder that divides two numbers.

Month function: Find the month for a specified date or a date in a reference cell.

Now function: gives the current system date and time.

or function: Returns logical "False (FALSE)" only if all parameter values are logical "false" (false), otherwise the logic "true (True)" is returned.

Rank function: Returns the rank of a value in a column of values relative to other values.

Right function: Intercepts a specified number of characters, starting with the last character of a text string.

Subtotal function: Returns subtotals in a list or database.

22. mod function

Function Name: MOD

Main function: To find the remainder of the division of two numbers.

Use format: MOD (number,divisor)

Parameter Description: number represents divisor; divisor represents divisor.

Application Example: Input formula: =mod (13,4), confirmed after the result "1".

Special reminder: If the divisor parameter is zero, the error value "#DIV/0!" is displayed; the MoD function can be represented by a function INT: The formula can be modified to: =13-4*int (13/4).

23. Month function

Function Name: MONTH

Main function: Find the month for a specified date or a date in a reference cell.

Use format: MONTH (Serial_number)

Parameter Description: Serial_number represents the specified date or referenced cell.

Application Example: Input formula: =month ("2003-12-18"), confirm, show 11.

Special reminder: If it is a given date, enclose it in double quotation marks, and if you modify the above formula to: =year ("2003-12-18"), return the value "2003" for the year.