• Excel Video Tutorials

Built-in Functions in Excel



Built In Functions

MS Excel has many built in functions, which we can use in our formula. To see all the functions by category, choose Formulas Tab ยป Insert Function. Then Insert function Dialog appears from which we can choose the function.

Built In Functions

Functions by Categories

Let us see some of the built in functions in MS Excel.

  • Text Functions

    • LOWER โˆ’ Converts all characters in a supplied text string to lower case

    • UPPER โˆ’ Converts all characters in a supplied text string to upper case

    • TRIM โˆ’ Removes duplicate spaces, and spaces at the start and end of a text string

    • CONCATENATE โˆ’ Joins together two or more text strings.

    • LEFT โˆ’ Returns a specified number of characters from the start of a supplied text string.

    • MID โˆ’ Returns a specified number of characters from the middle of a supplied text string

    • RIGHT โˆ’ Returns a specified number of characters from the end of a supplied text string.

    • LEN โˆ’ Returns the length of a supplied text string

    • FIND โˆ’ Returns the position of a supplied character or text string from within a supplied text string (case-sensitive).

  • Date & Time

    • DATE โˆ’ Returns a date, from a user-supplied year, month and day.

    • TIME โˆ’ Returns a time, from a user-supplied hour, minute and second.

    • DATEVALUE โˆ’ Converts a text string showing a date, to an integer that represents the date in Excel's date-time code.

    • TIMEVALUE โˆ’ Converts a text string showing a time, to a decimal that represents the time in Excel.

    • NOW โˆ’ Returns the current date & time.

    • TODAY โˆ’ Returns today's date.

  • Statistical

    • MAX โˆ’ Returns the largest value from a list of supplied numbers.

    • MIN โˆ’ Returns the smallest value from a list of supplied numbers.

    • AVERAGE โˆ’ Returns the Average of a list of supplied numbers.

    • COUNT โˆ’ Returns the number of numerical values in a supplied set of cells or values.

    • COUNTIF โˆ’ Returns the number of cells (of a supplied range), that satisfies a given criteria.

    • SUM โˆ’ Returns the sum of a supplied list of numbers

  • Logical

    • AND โˆ’ Tests a number of user-defined conditions and returns TRUE if ALL of the conditions evaluate to TRUE, or FALSE otherwise

    • OR โˆ’ Tests a number of user-defined conditions and returns TRUE if ANY of the conditions evaluate to TRUE, or FALSE otherwise.

    • NOT โˆ’ Returns a logical value that is the opposite of a user supplied logical value or expression i.e. returns FALSE if the supplied argument is TRUE and returns TRUE if the supplied argument is FAL

  • Math & Trig

    • ABS โˆ’ Returns the absolute value (i.e. the modulus) of a supplied number.

    • SIGN โˆ’ Returns the sign (+1, -1 or 0) of a supplied number.

    • SQRT โˆ’ Returns the positive square root of a given number.

    • MOD โˆ’ Returns the remainder from a division between two supplied numbers.

Advertisements