View Post

Using Excel to Build Randomizers

In Basic, Formulas by Garrett Dorman0 Comments

Occasionally, the need for a random number will surface in Excel. Fortunately, creating a random number is quite simple, given Excel has a built in function for this task: the RAND function. Using this function, along with some other associated functions gives you all the tools you need to create any sort of randomizer you would need. When creating a randomizer, the central function used is the RAND function. The RAND function looks like this: =RAND() It is a very simple function in principle, containing no arguments. However, there are some subtleties about this function that are very important. First, …

View Post

How to use the vLookup Function in Excel

In Formulas, Intermediate by Garrett Dorman0 Comments

Imagine having a spreadsheet with thousands of entries. Also imagine needing to find a number for one of those entries. Maybe a phone number from a list of employees or a price for a specific item. This is a common problem faced by many Excel users around the globe. However, using Excel’s various lookup functions, this task becomes easy. By the end of reading this, you will be able to use several of these functions to find any information you need, no matter how many entries have to be sorted through to find it. The cornerstone on searching through Excel …

View Post

Using the IF Formula

In Basic, Formulas by theexcelpert0 Comments

One of the most powerful statements in Excel, the IF statement can be endlessly customized and nested within other formulas to accomplish almost anything you want. The basic premise is that you can use the IF formula to test if a condition is TRUE or FALSE. If the condition is met, or TRUE, then you can have the formula output X, and if the condition is not met, or FALSE, then the formula will output Y. In this case, both X and Y are rules the formula will follow based on the result of the condition specified. If that totally …