Ms Excel Function and Its Types

Functions and its Types

Formulas or functions are very important in Excel when we want to do some calculations like - adding some cells of a column, multiplying one number by another, averaging the data of a range, etc., then we can formulas for that calculation. Let's use a formula that is filled in the cell where we want to show the result of the calculation. Formulas in MS Excel always start with an equal sign (=)

. Alex has per-defined formulas called functions that can perform various types of functions such as addition, occurrence, multiplication, division, date, time etc. These types are. Which is as follows.

·         Matt or String

·         Date & Time

·         Text

·         Financial

·         Logical

·         Statically

·         Lookup or reference

Using Function: - It is used in two ways.

By typing Director: - In this, type the function after the sign of = and insert Argument in it. And finally, you can get the result by clicking Inter or clicking.

Through menu: - On clicking Insert menu → Function, the function dialog box appears. In which the function is selected. And click on the OK button. And then give his arguments in it and click on the OK button.

 Matt or String Function

1. SUM - 1. SUM (): - Numbers are added by this function. In this, the value, cell address or cell range can be given.

Example - SUM (a: as)

2. SQ

RT - With the help of this function any number of SQUARE ROOT is extracted. In its argument, we give or give the cell address of a number. Whose SQUARE ROOT is to be extracted.

Example - SQ RT (25)

3. odd - With this function even number can be converted to odd number.

Example - odd (80)

4. even - By this function odd number can be converted into even number.

Example: - = even (79)

5. MOD - The remainder of any number is extracted with the help of this function. Two arguments are given in it.

Example - MOD (26,5)

6.POWER - The power of any number can be calculated from this function. Two arguments are given in this, first number, second power.

Example - POWER (5,2)

7. ABS - It extracts absolute value from it. That is, if there is any sign. Then it is removed. It takes a number in the argument.

Example - abs (-125)

8.Fact - With the help of this function, a factorial number of any number can be removed. It takes a number in the argument. Like is a Factorial of 5. 1 * 2 * 3 * 4 * 5 = 120

Example -fact (5)

9. INT - You can extract the integer value of any number from this function. It takes a number in the argument.

Example -fact (123.34

Text Function

This function is used for tact. Hence, they are called tact function. This is the following

1.    UPPER - This function converts the lower-case letter to a capital letter.

·         Syntax: - UPPER(TEXT)

·         Example - UPPER (“Cyber diary Solutions”)

·         Result - CYBER DAIRY SOLUTIONS

2.    LOWER - This function converts the upper-case letter to lower case letter.

·         Syntax - LOWER(TEXT)

·         Example - LOWER (“CYBER DAIRY SOLUTIONS”)

·         Result - cyber diary solutions

3.    Proper - This sets the function text to the proper case.

·         Syntax - proper (TEXT)

·         Example - proper (“CYBER DAIRY SOLUTIONS”)

·         Result - Cyber diary Solutions

4. Len- It counts the characters of Function text.

·         Syntax: = Len (TEXT)

·         Example - Len ("Computer")

·         Result - 8

5.left - This function extracts the letters of the word from the left side. Tact and how many letters to remove in it. Its number has to be given.

·         Syntax - Left (TEXT, Number)

·         Example - Left(“Computer”,3)

·         Result - Com

6. Right - This function extracts the letters of the word from the right side. Tact and how many letters to remove in it. Its number has to be given.

·         Syntax- Right (TEXT, Number)

·         Example - Left ("Computer", 2)

·         Result: - err

7. TRIM - This function eliminates the space behind the front of the tactic.

·         Syntax -Trim (TEXT)

·         Example - Left ("Computer")

·         Result: - Computer

8.MID - This function extracts words from between the letters. In this, the letter has to be extracted from the tact and where as an argument. And how many letters to remove. Let's give his number.

·         Syntax -MID (TEXT, START NUMBER, END NUMBER)

·         Example - Left (“MICRO COMPUTER”,6,7)

·         Result - COMPUTER

DATE OR TIME FUNCTION

DATE-

1.    NOW - It gives the current date and time of Function Computer.

·          Syntax -Now

·          Example - Now

·         OUT PUT- 10/20/2012 19:16

2. DAY - This function takes days out of DATE.

·         Syntax - day(date)

·         Example -day (22/7/2016)

·         Output -20

3. MONTH - This function extracts the month from DATE.

·         Syntax: - month (date)

·         Example - month (10/20/2011)

·         Output - 10

4. year - This function extracts the year from DATE.

·         Syntax: - year (date)

·         Example - year (10/20/2011)

·         Output - 2011

5.    Today - It gives the function current date output.

·          Syntax -Today

·          Example -Today

·         Output- 10/20/2011

6. Date- This function converts the given numbers into dates.

·         Syntax- date (year, month, day)

·         Example- date (2011,22,10)

·         Output - 22/10/211

Time Function

1. Time - This function changes the given hour, minute, second into time.

·         Syntax: - Time (hour, minute, second)

·         Example: - Time (4,30,10)

·         Output: - 4:30 AM

2. Second (): - This function returns the second output from the given time.

·         Syntax: - Second (Time)

·         Example: - Second (4:30)

·         Output: - 10

3. Minute - This function returns the minutes output from the given time.

·         Syntax: - minute (Time)

·         Example: - minute (4:30)

·         Output: - 30

4. Hour - This function gives the hour output from the given time.

·         Syntax: - hour (Time)

·         Example - hour (4:30)

·         Output: - 4