https://coolnup982.weebly.com/ivi-4-712-pc.html. Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS.It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets.
- First, learn basic formulas to get start with functions. Recommended Articles. This has been a guide to the features of MS excel. Here we discuss the top 9 features of Microsoft Excel that include Time Saving Shortcut Keys, Get Quick Sum of Numbers, Filtering Data, Paste Special Feature, etc.along with examples, and a downloadable excel template.
- Some of the features of MS Excel are add header and footer, find and replace command, password protection, data filtering, data sorting, built-in formulae, create different charts (pivot table report), automatically edits the result, formula auditing.
IF function, also known as conditional function, enables you to get corresponding results in Microsoft Excel spreadsheets when meeting the specific conditions.
How Does IF Function Work
The function syntax of IF function is: IF(logical_test,[value_if_true],[value_if_false]).
If the specified conditions evaluate to true, this function will return a value; If the specified conditions evaluate to false, another value will be returned.
For example, if the value in A1 is larger than 10, the formula: =IF(A1>10, 'More', 'Less or equal') will return 'More' as the result; if the value in A1 is not larger than 10, the formula will return 'Less or equal'.
When Should You Use IF Function
IF function is one of the most commonly used function in Microsoft Excel, it's very practical and also easy to grasp. Here are some pratical situations that you can make use of it to significantly save your time and effort. Let's have a look.
- Compare 2 Columns of Data in Excel
- Determine Whether Someone is Qualified (Pass or Fail)
- Evaluate the Level According to Specific Criteria
- Find Duplicates in an Excel Column
- Plus or Minus a Number if Specific Conditions are Met
How to Use IF Function in Pratical
1. Compare 2 Columns of Data in Excel
When there's a large amount of data in the table, it's difficult to judge whether the data in 2 columns are the same. On this occasion, IF function can do the job for you quickly and accurately.
Steps:
Enter the formula next to the columns that you want to compare.
Here I want to compare the data in A1 and B1 at first, so the formula can be: =IF(A1=B1,'Same','Different').
Press [Enter] or click anywhere outside the cell to see the result.
You can then drag your mouse to apply this formula to all cells in column C using fill handle.
2. Determine Whether Someone is Qualified (Pass or Fail)
Similarly, if you want to mark the students whose grades are above a specific score or below it, you don't need to judge their grades one by one which will doubtlessly take a lot of time.
Steps:
Assuming the students can pass with a score above 300, the formula can be: =IF(C2>300,'Pass','Fail'). Enter it beside the grade column.
Use fill handle to apply the formula to multiple cells.
3. Evaluate the Level According to Specific Criteria
There are many fields that need to be graded, like the quality of products and the scores of students. With IF function, you can evaluate the level very conveniently.
Premiere login net. Steps: How to check apple storage.
Confirm several scores as the points to divide different grades. In my case, I want to evaluate the grades of students in the table below, so the formula can be: =IF(C2<250,'D',IF(C2<350,'C',IF(C2<450,'B','A'))). It's the combination of several conditions, and the grades will be divided into 4 levels: A(>450), B(350~450), C(250~350), D(<250).
Enter the formula beside the existing column of scores, then use fill handle to apply it to all the selected cells. In this way the scores of students will graded according to the conditions you set within seconds.
4. Find Duplicates in an Excel Column
With IF function, you don't need to find the duplicates manually as well. The formula can do better and quicker than your eyes.
Steps:
Usb 3 0 hard drive. If the list of data is in column A, create a new column to return the result and enter the formula: =IF(COUNTIF(A:A,A2)>1,'Duplicates','').
Thus only the repeated data will be marked with 'Duplicates'.
5. Plus or Minus a Number if Specific Conditions are Met
If you've ever been in charge of the payroll in a company, you must be familiar with the situation that among all these employees, some people from specific departments have higher bonuses and some people with larger working years have higher salaries. At this point, how to calculate the wage for all the people without spending too much time?
You may already know the answer – IF function. If you are in a similar situation and need to process a huge amount of data, let Excel run it automatically.
Steps:
The process is all the same. Just enter the proper formula in a new formula and press enter to return the corresponding value. What you need to pay attention to is entering a right formula according to the function syntax and also your actual situation.
For example, if you want to add 500 to all the employees whose working years are more than 3, the formula should be like: =IF(D2>3,E2+500,E2).
Then use fill handle to apply it to other cells.
Data processing is not always so difficult as long as you use functions smartly and enter the right formula. IF function is one of the most powerful functions you can use a lot in work as well as daily life. Have a try, you'll love the feeling of solving practical problems so quickly and easily.
Relevant Reading
Well, you may have been thinking of how Microsoft Excel can assist you in the office. I have compiled this article to assist you to understand how Microsoft Excel can be of help to you in your office environment.
Microsoft Excel, which is part of the Microsoft Office software collection, has many significant functions. It's been used since very soon after the introduction of Microsoft computers. What's more is that this software is compatible with Windows, Android, Mac OS, and cloud computing users. Here are some of the top 5 uses of Microsoft Excel in the office.
1. Accounting
Microsoft Excel has been designed by Microsoft to meet accounting and financial needs. This includes budgeting, expenses tracking, loan calculators and financial reports.
Accounting refers to the process of recording comprehensive financial transactions for a particular business. The availability of numerous tools for calculation makes it an invaluable tool for accounting purposes in the office. It also has templates which makes the accounting processes much easier.
Job examples; auditors, accountants, forensic accountant, company secretary
2. Graphing
Refers to the use of graphs to represent statistical data. Data in Microsoft Excel Is usually organised in cells. These cells can be easily formatted and organised to represent data. This organised data can be used by various departments within the office to represent their statistical data in a visually appealing way. Since Excel has all the mathematical tools and graphs, this can be easily carried out in a cost-effective manner.
Job examples; architects, economist, an epidemiologist.
3. Data Organisation
Data organisation is one of the top business uses of the world's most popular business software. Data from the various units in an office are raw and consequently unorganised. Data that are commonly kept include employees' details, inventories and invoices.
Dealing with raw and unorganised data is a challenge especially when you require the data to come up with data-based findings or observations. Microsoft Excel comes in to help you organise data in your office in a more tidy and systematic manner. This organised data can be accessed and utilised more easily. Furthermore, it can also be used to analyse things like the rate of growth of the company.
Job examples: data officers, data analysts, data assistant, secretary.
4. Calculating
After using Excel for a while you will find out that it supports most mathematical calculations. From addition, multiplication, subtraction, division, average and even median, Excel has got you covered. You can, therefore, trust this software to cover all your calculation needs. Its organisation of data in cells also makes calculation easier. There are also different formulas available for use in Microsoft Excel. You can, therefore, customise Excel as your own calculator by bringing into the table your most used formulas.
Job examples: retail sales associate, accountant, mathematician, financial analyst, statistician
5. Managing Office Operations
Managing office transactions can be quite a headache sometimes. This is especially if the transactions are large. MS Excel helps you keep track of clients transactions, calendars appointments, plans and schedules.
Microsoft Excel can store this data in a well-tabulated manner, making your office work easier. What's more is that you can also set Excel to remind you of the plans and schedules when their time comes. This assists you to easily manage time and avoid missing out on important events.
Microsoft Excel Function Pdf
Job examples; company secretary, human resource manager, receptionist, office manager.