We’ll write a little more complicated formula in Excel Video 361. It might help to review Excel Videos 355 and 356 since today we’ll look for the third next available appointment for a new patient in the South location. To find an appointment that’s both new and south, we need to use multiplication in the IF statement. We’ll work through that formula example today and you can use the same logic to find a new patient in the south location on a certain day of the week.
Speaking of days of the week, there’s a preview at the end of this Excel Video for where we’ll go next. You’ll see me try to find an appointment (from a very small list of fake appointments) meeting a bunch of criteria that are easier to manage because the criteria are outside the big, long formula. Stay tuned next time and I’ll show you how I built that formula. Thanks for watching.
