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.