no i didn’t do the wrong range it’s just there it goes uh this column was a date range or a date column for whatever reason let me get rid of that and then we can do equals min and we’ll do again we’ll do the salary and at a quick glance we can see that pam beasley is making the least and 65 000 is michael scott who’s making that so super simple it shows the max it shows the min you can select a range there you go let’s move on to if and ifs IF/IFS now if is um i think pretty straightforward so all you’re going to do is you’re going to say if this then that ifs is a little bit different so if you can you can put multiple conditions and as we’re writing it i’ll show you kind of what it the conditions that need to be met all right so we’re gonna click right here we’re gonna say equal we’re gonna do if hit tab and we need a logical test