Excel Formulas List Pdf, All Excel Formulas with Examples. Advanced Excel Formulas PDF.
| PDF Name | Excel Formulas List Pdf |
| No. of Pages | 2 |
| PDF Size | 483 kb |
| Language | English |
| PDF Category | Education & Jobs |
| Download Link | Available |
| Published/Updated | February 10, 2023 |
| Source / Credits | mypdf |
| Uploaded By | MyPdf |
Excel Formulas List Pdf
| SUM | Adds up a range of cells |
| AVERAGE | Calculates the average of a range of cells |
| COUNT | Counts the number of cells in a range that contain numbers |
| MAX | Returns the maximum value in a range of cells |
| MIN | Returns the minimum value in a range of cells |
| IF | Performs a logical test and returns one value if the test is true, and another value if it’s false |
| VLOOKUP | Searches for a value in the first column of a table, and returns a corresponding value in the same row from another column |
| HLOOKUP | Searches for a value in the first row of a table, and returns a corresponding value in the same column from another row |
| INDEX | Returns the value of a cell in a specified row and column of a range |
| MATCH | Searches for a value in a range and returns the relative position of the value within the range |
| CONCATENATE | Joins two or more text strings into one string |
| LEFT | Returns a specified number of characters from the start of a text string |
| RIGHT | Returns a specified number of characters from the end of a text string |
| MID | Returns a specified number of characters from a text string, starting from a specified position |
| LEN | Returns the length of a text string (the number of characters) |
| DATE | Returns the current date |
| TIME | Returns the current time |
| NOW | Returns the current date and time |
| DAY | Returns the day of the month for a given date |
| MONTH | Returns the month for a given date |
| YEAR | Returns the year for a given date |
| ROUND | Rounds a number to a specified number of decimal places |
| ROUNDUP | Rounds a number up to a specified number of decimal places |
| ROUNDDOWN | Rounds a number down to a specified number of decimal places |
| FLOOR | Rounds a number down to the nearest integer |
| CEILING | Rounds a number up to the nearest integer |
| ABS | Returns the absolute value of a number (removes the sign) |
| MOD | Returns the remainder of a division operation |
| SQRT | Returns the square root of a number |
| EXP | Returns the result of raising a number to a power |
| LN | Returns the natural logarithm of a number |
| LOG10 | Returns the base-10 logarithm of a number |
| PI | Returns the value of Pi |
| SIN | Returns the sine of an angle |
| COS | Returns the cosine of an angle |
| TAN | Returns the tangent of an angle |
| ASIN | Returns the arcsine of a number |
| ACOS | Returns the arccosine of a number |
| ATAN | Returns the arctangent of a number |
| AND | Returns TRUE if all arguments are TRUE, and FALSE otherwise |
| OR | Returns TRUE if any argument is TRUE, and FALSE otherwise |
| NOT | Reverses the logic of an argument (returns TRUE if the argument is FALSE, and FALSE if the argument is TRUE) |
Excel Formulas with Examples
Excel has a vast range of formulas that can perform various calculations and manipulations of data. Here is a list of some of the most commonly used Excel formulas, along with examples:
- SUM: This formula adds up a range of cells. Example: =SUM(A1:A5)
- AVERAGE: This formula calculates the average of a range of cells. Example: =AVERAGE(A1:A5)
- COUNT: This formula counts the number of cells in a range that contain numbers. Example: =COUNT(A1:A5)
- MAX: This formula returns the highest value in a range of cells. Example: =MAX(A1:A5)
- MIN: This formula returns the lowest value in a range of cells. Example: =MIN(A1:A5)
- IF: This formula returns one value if a condition is true and another value if it’s false. Example: =IF(A1>10, “Greater than 10”, “Less than or equal to 10”)
- VLOOKUP: This formula searches for a value in the first column of a table and returns a value in the same row from a specified column. Example: =VLOOKUP(A1, A2:B5, 2, TRUE)
- HLOOKUP: This formula searches for a value in the first row of a table and returns a value in the same column from a specified row. Example: =HLOOKUP(A1, A2:B5, 2, TRUE)
- INDEX/MATCH: This formula returns the value of a cell in a specified row and column of a table. Example: =INDEX(A2:B5, MATCH(A1, A2:A5, 0), 2)
- CONCATENATE: This formula combines text from multiple cells into one cell. Example: =CONCATENATE(A1, ” “, A2)
This is just a brief overview of some of the most common Excel formulas. There are many more formulas available in Excel that can perform various functions, including statistical analysis, text manipulation, and financial calculations.
So, don’t delay and download the PDF from the link given below.
You can download the Excel Formulas List Pdf the link given below:
Report This: We DO NOT own any copyrights of this PDF File. If you want this All Country Code Number List Pdf to be removed or if it is copyright infringement, do drop us an email at email@mypdf.in and this will be taken down within 24 hours!