IF Function in Excel

The IF function allows you to run a true-or-false test and return specific values based on the result. For example, if you’re doing annual employee reviews and whether each employee gets a raise is based on how well they’ve performed in the last year, you could run a...

Concatenate Function in Excel

If you want to combine multiple cells into one, or take a cell and add additional text or numbers, one function you can use is the & function described in this post. Another option is the concatenate function. Start with =Concatenate() and add the cells you want...

Combining Cells and Splitting One Cell Into Multiple in Excel

Have you ever had information in multiple cells that you want to combine into one? Maybe you have a list of names where the first name is in one column and the last name is in another, or address information is split out as street address, city, state, and zip code....

Creating a Dropdown List in Excel

Suppose you have a report where users should only be able to enter particular values in a cell. You can create a dropdown menu to limit what they’re able to choose from. Using the example from this VLOOKUP, if you want to look up an employee’s salary, you should only...