by @nicholasware | Feb 26, 2018 | Uncategorized
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...
by @nicholasware | Feb 18, 2018 | Uncategorized
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...
by @nicholasware | Feb 11, 2018 | Uncategorized
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....
by @nicholasware | Feb 4, 2018 | Uncategorized
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...