Select Page

Excel Video 147 Nesting IF 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...

Excel Video 146 IF

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

Excel Video 145 Rate and Future Value

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