THE COMMOM FUNCTION IN EXCEL (PART 2)

THE GROUP OF ARITHMETIC FUNCTIONS

- SUM(n1, n2,...): The SUM function adds all the numbers that you specify as arguments. Each argument can be a range, a cell reference, an array, a constant, a formula, or the result from another function

                             EX: SUM(A1,A2,A3), SUM(A3:C20).

- ABS (parameters): Returns the absolute value of a number, the absolute value of a number is the number without its sign.

                              EX: ABS(A4-100)

- ROUND (parameters, n): The ROUND function rounds a number to a specified number of digit                              EX: ROUND (8.54,1) --> 8.5

- SQRT (parameters): Returns a positive square root.

- AVERAGE (range of parameters): Returns the average (arithmetic mean) of the arguments

                             EX: AVERAGE (7,8,9) --> 8.

- COUNT(range of parameters): Count Function is Use to add the number of Cell which is in a selected range of cell. Its only count up Numbers, not alphabet and symbols and Count Function ignore those cells which contains symbols, text and an Empty cell

                              EX: COUNT(34,54,"NAM") --> 2.

- COUNTA(range of parameters): The Excel Counta function returns a count of non-blanks within a supplied set of cells or values.The function is commonly used to return the number of non-blank cells in a range. However, as well as ranges of cells, the Counta function can directly received arrays of values, which are not stored in cells.

                              EX: COUNT(34,54,"NAM") --> 3.

- COUNTIF(range of parameters): Counting all the cell that contain the data follow a condition.

                              EX: COUNTIF(A2:A25,">5")

- MIN(range of parameters): Returns the number that has the smallest values.

- MAX(Range of parameters): Returns the number that has max largest values.

- SUMIF(range,criteria,[sum_range]): sum the values in a range that meet criteria that you specify.

                              EX: SUMIF(A1:D20,"<0")

                                            THE GROUP OF LOGIC FUNCTIONS

All the logical 1, logical 2...is the logic variables to receive TRUE or FALSE.

- AND (logical 1, logical 2...): Returns TRUE if all its arguments evaluate to TRUE; returns FALSE if one or more arguments evaluate to FALSE. One common use for the AND function is to expand the usefulness of other functions that perform logical tests. 

                               EX: AND(A2>5=5, B2<10, C2>8)

- OR (logical 1, logical 2....): Returns TRUE if any argument is TRUE; returns FALSE if all arguments are FALSE.

- NOT(logical): Reverses the value of its argument. Use NOT when you want to make sure a value is not equal to one particular value. If logical is FALSE, NOT returns TRUE; if logical is TRUE, NOT returns FALSE.

- IF(logical_test, [value_if_true], [value_if_false]): The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE

                               EX: IF(3<5,1,0)-->1

                                     IF(3>5,1,0)-->0

                                             THE GROUP OF TIME FUNCTIONS

-TODAY(): Returns the serial number of the current date. The serial number is the date-time code used by Excel for date and time calculations. If the cell format was General before the function was entered, Excel changes the cell format toDate. If you want to view the serial number, you must change the cell format to General or Number.

-NOW(): Returns the serial number of the current date and time

- DAY(): Returns the serial number of a particular date.

- MONTH(): Returns the month of a date represented by a serial number

- YEAR(): Returns the year corresponding to a date. The year is returned as an integer in the range 1900-9999.