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....
by Nate Moore | Apr 11, 2011 | Functions
Excel Video 147 nests IF functions. By nesting, I mean we’ll put an IF function inside of another IF function so that we’ll have 3 options instead of the 2 options we normally get with IF. I’ll show you two different ways to nest the IF function so you customize your...
by Nate Moore | Apr 6, 2011 | Functions
Excel Video 146 introduces the IF function, a powerful tool to add versatility to your formulas. We’ll start with two basic examples. The structure of the IF function is =IF(logical test, value if the test is true, value if the test is false). The logical test can be...
by Nate Moore | Apr 4, 2011 | Functions
Excel Video 145 wraps up our discussion of financial functions in Excel. There are many, many more financial functions out there, but these are the basics a medical practice manager might find helpful. The RATE function is very similar to the PMT function we’ve...