Admin 
The IF Function with a single condition IF Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. Use IF to conduct tests on values and formulas. Syntax IF(logical_test,value_if_false) A logical test is any value or expression that can be evaluated to TRUE or FALSE. For
Advanced excel formulas can be used to lookup values or text in Excel and return the relative cell address. An INDEX function can be used to MATCH the lookup value in a range of cells. INDEX function can be used in two ways, INDEX reference and INDEX array The reference form returns the reference to
If formula can be used together with VLookup formula to return an exact match of values and an empty string if the value is not found. The combination of these formulas makes excel tasks more effective. Example: Look for a commission using the Vlookup function Calculate Bonus by getting a product of total and commission.
Excel spreadsheet is a common tool used by every accountant or financial analyst to analyze, report, and share financial information. Some basic excel functions let you perform complex calculations and produce useful models making your work more effective and easier. Excel can become a more versatile tool if you increase your knowledge on more other
What are Macros? They are a series of commands used to automate a repeated task. This can be run whenever the task must be performed. How to access Macros Click on the 'View' tab In the end, you'll find the function 'Macros' arranged in the Macros group. Click the arrow under 'Macros' where you can
The IF function is used to perform a logical test and return one value if the condition is TRUE and another for FALSE results. Combining AND, OR, and IF function varies the condition for testing the cells. The OR and AND functions are used to test multiple conditions and depending on which function is used,
COUNTIF function is one of the most common excel functions used for counting numbers within a specific range. The number of cells in the range should match the supplied criteria. Users need to specify single or multiple criteria to get the result. If you want to count cells based on multiple criteria, you can use
In this tutorial, we will be discussing how to create a basic line graph on Microsoft Excel 2016. Line graphs are generally used to show trends of a series of data points. It is typically used to show the behavior of a metric / data set over time (week, months year…). Here are the steps
VLOOKUP is one of the most useful Excel functions. The function is used to search for specific values defined and returns the match-in value from another column. The VLOOKUP function, just as the name looks up a value in the first column of a specified range of cells and then returns the results on the
There are various methods of returning a value from a Table array based on more than one criteria. Vlookup is used when there is only one criterion (condition). In this tutorial, we will be discussing the method involving INDEX and MATCH. Let us consider an example, see the below illustration: The Formula in C2 is: