Microsoft Excel is a powerful program that helps you work with numbers and data. You can do calculations, make charts and graphs, and analyze information. One of the best things about Excel is that you can use formulas to do math with your data.
The MS Excel Formulas List With Examples PDF is a helpful document that lists all the formulas you can use in Excel. It also includes examples showing you how to use each formula.
Excel Formulas List
- SUM
- COUNT
- COUNTA
- COUNTBLANK
- AVERAGE
- MIN Excel
- MAX Excel
- LEN Excel
- TRIM Excel
- IF Excel
Some of the most commonly used Excel formulas include:
SUM
This formula adds up a group of numbers. For example, =SUM(A1:A5) adds all the values in cells A1 to A5.
AVERAGE
This formula finds the average of a group of numbers. For example, =AVERAGE(A1:A5) calculates the average of the values in cells A1 to A5.
COUNT
This formula counts how many cells in a group have numbers. For example, =COUNT(A1:A5) tells you how many cells in A1 to A5 have numbers in them.
IF
This formula checks a condition and gives one result if it’s true and another if it’s false. For example, =IF(A1>10,"Yes","No") will say “Yes” if the value in A1 is greater than 10 and “No” if it is not.
VLOOKUP
This formula looks for a value in a table and gives back a related value. For example, =VLOOKUP(A1, Table1, 2, FALSE) looks for the value in cell A1 in Table1 and returns the related value from the second column.
MAX
This formula finds the highest number in a group. For example, =MAX(A1:A5) gives you the highest value from cells A1 to A5.
MIN
This formula finds the lowest number in a group. For example, =MIN(A1:A5) tells you the lowest value in cells A1 to A5.
These are just a few of the many formulas you can use in Excel. By using these formulas, you can do complex calculations and analyze data quickly and easily. An MS Excel Formulas List With Examples PDF can be a helpful guide for both new and experienced Excel users to improve their skills and work more efficiently.
MS Excel Formula & Functions Basics
Every formula and function in Excel starts with an equal sign (=).
To make a formula, first click on the cell where you want to put the formula. You can also select multiple cells with your mouse.
The main symbols you use for calculations are:
- + for adding
- – for subtracting
- * for multiplying
- / for dividing
When doing math in formulas, remember the BODMAS rules:
- Brackets
- Over
- Division
- Multiplication
- Addition
- Subtraction This helps you know which part to calculate first.
It’s a good idea not to type things like tax rates directly into your formulas. Instead, write the rate in a different cell and then refer to that cell in your formula.
If you want to use the same formula in a column, create the formula in the first cell, and then use Autofill to drag it down to the other cells.
Functions in Excel are written like this: =name(arguments). Here, “name” is the function you want to use (like SUM or VLOOKUP), and “arguments” are the cells or ranges you’re using in that function.
When a function has more than one argument, make sure to separate them with a comma.
If you need to use text in a function, put quotation marks (” “) around the text.
File Details
| Data | Details |
|---|---|
| File Name | MS Excel Formulas List With Examples PDF |
| File Type | |
| File Size | 51 KB |
| PDF Quality | Very Good |
| No. of Pages | 10 |
| Category | Computer Awareness PDF |
| Language | English |
File Preview
🔰 Related PDF:
Computer and MS Office Basic Shortcut Keys PDF
✅ © Click Here for the removal of the Copyrighted Content
Disclaimer for PDF Download:
"Affairshub.in" doesn’t aim to promote or allow piracy in any way. We do not own any of these books. We neither create nor scan this Book. The Images, Books & other Contents are copyrighted to their respective owners. We are providing PDFs of Books that are already available on the Internet, Websites, and Social Media like Facebook, Telegram, Whatsapp, etc. We highly encourage visitors to Buy the Original content from their Official Sites.
Please note that we are not responsible for the content of the PDF document and cannot guarantee its accuracy or reliability. By downloading and using the PDF document, you agree to accept all responsibility for its use and any consequences that may result from it.
Thank you for your understanding and cooperation.
