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...

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...