by Nate Moore | Apr 27, 2011 | Functions
Excel Video 152 describes two ways to concatenate functions in Excel. Even if concatenate didn’t have my name in it, it would still be a handy function. Concatenate means to put something on the end of something else, or to stuff things together. You’ll find it handy...
by Nate Moore | Apr 25, 2011 | Functions
Excel Video 151 explains how to use IFERROR to replace all of Excel’s error messages with something more appropriate. IFERROR is a simple Excel function that takes a formula and evaluates it. If the formula works, fine. Excel will show you the result of the formula....
by Nate Moore | Apr 20, 2011 | Functions
When you’re done with Excel Video 150, you might be thinking that NOT is a lot like the devil, always telling you bad is good and good is bad. The NOT function simply takes something that’s true and returns false, or something that’s false and returns true. It’s hard...
by Nate Moore | Apr 18, 2011 | Functions
Excel Video 149 continues our discussion of logical functions by introducing OR. In Excel Video 148, all of the conditions had to be true to make the statement true. This time, only one of the conditions needs to be true to make the statement true. The IF statement in...
by Nate Moore | Apr 13, 2011 | Functions
Excel Video 148 adds the AND function to our collection of logical tests in Excel. The AND function simply evaluates a list of conditions, each separated by a comma. If all of the conditions are true, AND is true. If even one of the conditions is false, AND is false....
