Excel formulas pdf

MS Excel has many inbuilt in functions that we can use in our formula. If you want to see all the functions by category choose Formulas Tab and then Insert Function.

Then Insert function Dialog appears from which we can choose function. 

Some important functions of Excel by categories are:

Text Functions

• Lower: Converts all characters in a given text string to lowercase.
• UPPER: Converts all characters in a given text string to uppercase
• CONCATENATE: It will join together two or more text strings
• LEFT: It will return a specified number of characters from the beginning of a supplied text string
• RIGHT: Returns a specified number of characters from the end of a supplied text

Date & Time

• TIME: It will return a time, from a user-given hour, minute, and second.
• NOW: It will return the current date & time
• TODAY: It will return current today’s date.

Statistical

• SUM: It will return the sum of a given list of numbers
• MAX: It will return the largest value from a list of given numbers
• COUNTIF
  how to use a function in excel
  how to enter a formula in excel without using parentheses