IF statement Returns one value if a condition you specify evaluates to TRUE and another value if it evaluates to FALSE. An if statement with four outcomes requires you to test three conditions The excel If () function is used to test a single condition that returns a value if the condition is met otherwise
VLOOKUP function returns a corresponding value of the first instance in a lookup value. The function searches specific values defined and returns the matching value in 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
IF statement is used to test whether a certain condition is met. Sometimes you can have more than one condition to test, thus creating an If statement within another if statement (nested if statement). This enables you to come up with a statement with many possible outcomes. The excel If () function is used when
Concatenate is an excel function that allows you to join two or more strings together. When creating a Pivot table, you may want to combine data from two or more columns to form a single column. An example, you may wish to combine the names field with the address field to form a single column
A Pivot table is one of the powerful features in excel for any data analyst. The feature allows you to extract data from a large dataset. You can also create a multi-level Pivot table to analyze data. To help you understand how to create a nested PivotTable, we will use a data set consisting of
1. TODAY function This function returns the current date. This function is useful when you want the current date displayed on your worksheet. The returned value will be updated each time the worksheet is recalculated or when you open the workbook. Syntax =TODAY () The function has no arguments. Example =TODAY() this function returns current
Find and replace is an excel feature used to search for specific data in an excel worksheet or within a workbook and what you do with the data found. This article will explore different ways you can use find and replace together with using advanced find features. Scanning through columns and rows in a large
Sometimes when working with Excel, you may need to do a calculation that involves several formulas. One way of handling this is to break each formula out in its own cell. Another more elegant solution is to nest those formulas or combine them. Let's look at an example. The above sheet is a bonus calculator
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