Excel All Formulas

Excel formulas across different categories:


1. Math and Trigonometry:

   - SUM: Adds up all the numbers in a range.

   - AVERAGE: Calculates the average of a range of numbers.

   - MAX: Returns the maximum value in a range.

   - MIN: Returns the minimum value in a range.

   - ROUND: Rounds a number to a specified number of digits.


2. Logical Functions:

   - IF: Checks whether a condition is met and returns one value if true and another value if false.

   - AND: Returns TRUE if all of its arguments evaluate to TRUE, and FALSE otherwise.

   - OR: Returns TRUE if any argument is TRUE, and FALSE otherwise.


3. Text Functions:

   - CONCATENATE: Joins two or more text strings into one string.

   - LEFT: Returns the leftmost characters from a text string.

   - RIGHT: Returns the rightmost characters from a text string.

   - LEN: Returns the length of a text string.


4. Date and Time Functions:

   - TODAY: Returns the current date.

   - NOW: Returns the current date and time.

   - DATE: Returns the serial number of a particular date.


5. Lookup and Reference Functions:

   - VLOOKUP: Looks up a value in a table and returns a corresponding value from another column.

   - HLOOKUP: Looks up a value in the top row of a table and returns a corresponding value from another row.

   - INDEX: Returns the value of a cell in a specified row and column of a range.

   - MATCH: Searches for a specified value in a range and returns the relative position of that item.


6. Statistical Functions:

   - STDEV: Calculates the standard deviation based on a sample of numbers.

   - AVERAGEIF: Calculates the average of a range based on specified criteria.

   - COUNTIF: Counts the number of cells within a range that meet a single criterion.


7. Financial Functions:

   - PV: Calculates the present value of an investment.

   - FV: Calculates the future value of an investment.

   - PMT: Calculates the payment for a loan based on constant payments and a constant interest rate.


These are just a few examples, and there are many more Excel formulas available for various purposes. You can access Excel's built-in help or online resources for a comprehensive list and detailed explanations of each formula.

Next Post Previous Post
No Comment
Add Comment
comment url