Logic functions: The If function

- [Instructor] The logical function group … contains some of the most interesting … and powerful functions available in FileMaker, … but by far the most useful one … is something that's called the If function. … Actually you're going to go into File, Manage, Database … and I'm going to go into this Commission field … that's already giving us the subtotal times 5%. … Now, how would the If function work in here? … Well, If, in short, actually introduces conditions … learn one thing in this whole course, … I hope you take away how the If function … that can be used in many different ways. … So let me talk about that specifically. … if this test is true then do one result, … Now in plain English you might think of it as, … if it's raining outside, that would be our test, … then bring an umbrella. … But if it's false, if it's not raining, … then wear your sunglasses. … So let's say in this specific example with commission, … have a 5% commission, … instead what we want to do … So that test is if the invoice subtotal is over 1000. …