so you’re going to see this pattern right if this is our conditional or logical test so if this is true this is what’s going to be returned so you’ll notice that it’s just a pretty simple pattern we can just do random things so if it’s equal to sales um i will just do the same one if that is equal to say hr we can say fire immediately and now we’re going to say if it’s equal to regional manager i’m going to say give christmas bonus and we’ll close the parentheses and let’s see what we get so as you can see there’s no default value for true or false like like this one there was a logical test and if it was true there was a value and if it was false there’s a value so for every single one you’ll get a value for this one that’s not exactly going to happen as you can see there are these nas now when that happens it just means nothing met that condition so we never said anything about supplier relations we never said anything about accountants but if it was part of that if’s statement then it got something and so that is how the ifs works now let’s move on to length Len this is exactly what we’re going to do but you know some of the uses for this for the length i’ve used it for a lot of different things um one thing that i’ve used it for in the past and you know max and ifs you know you can use it for