WEBVTT

1
00:00:01.530 --> 00:00:07.440
William Rosener: hello, Dr rosen or welcome back this instructional video will be working with formulas to compute page.

2
00:00:07.950 --> 00:00:16.529
William Rosener: Whether or not an employee can serve all calm and we're running a restaurant here we're going to assume that them play has to be at least 21 I think this parish one State to the next.

3
00:00:17.039 --> 00:00:24.210
William Rosener: They want to go ahead and determine whether the employee is eligible for a rp is kind of retirement eligibility will go ahead and find.

4
00:00:24.870 --> 00:00:36.090
William Rosener: The age of the average employee the youngest employee currently 18 the oldest employee number of employees that are less than 40 and those that are eligible for a rp.

5
00:00:36.840 --> 00:00:43.590
William Rosener: Or we can currently see how i'm going to make a change here just to show you all the effects of the change that can happen because all this is done using formulas.

6
00:00:43.950 --> 00:00:59.310
William Rosener: So let's go ahead and change john classes page here so right now, this is the youngest employee, so all of this data and this data will change my making this one change here so rather than being born in 2004 and put in 1950.

7
00:01:00.270 --> 00:01:12.510
William Rosener: Having done so here's the employees, new age, they can now serve alcohol aren't aarp eligible and you're also going to find all this information has changed as well.

8
00:01:13.770 --> 00:01:16.110
William Rosener: But now that we know, want to do let's get started here.

9
00:01:16.590 --> 00:01:25.230
William Rosener: Why don't you go ahead and change one of these, maybe the first one change it, you can, if you want you put your first name here put your last name why don't you well.

10
00:01:25.650 --> 00:01:34.500
William Rosener: If you're worried about someone find out your birthday it's your birthday, as one of these, and then maybe you could even put your own first name and last name here as well.

11
00:01:34.950 --> 00:01:44.580
William Rosener: But the first step, what to do is go ahead and compute the page and to do that i'm going to simply come right up here, I could type in here i'm going to put equals today.

12
00:01:46.470 --> 00:01:49.920
William Rosener: Know subtract that from this case see to.

13
00:01:53.160 --> 00:02:01.230
William Rosener: Okay, and i'm now going to format that, rather than being a date i'm gonna highlight that in turn around and format it as general.

14
00:02:02.490 --> 00:02:12.990
William Rosener: So, and again that as this video starts to get a little bit older than you're going to start finding that some of these dates won't be what you're seeing will not be the same as what's the video.

15
00:02:14.190 --> 00:02:15.780
William Rosener: So started in March 15.

16
00:02:17.010 --> 00:02:30.180
William Rosener: So anyway, this employee is 1919 days old I think that's going to vary here, depending on when you watch the video so now what i'm going to do, simply take all this information.

17
00:02:31.410 --> 00:02:32.190
William Rosener: and divided.

18
00:02:33.480 --> 00:02:40.830
William Rosener: By 365.25 as the link here so Now I know this employee is 24.41.

19
00:02:41.850 --> 00:02:47.010
William Rosener: years old, well, most people don't go around with the fraction someone simply put an iot here.

20
00:02:49.410 --> 00:02:57.930
William Rosener: and close the parentheses so that's going to return the integer portion of that and Sure enough, this employee has 24 years old.

21
00:02:58.530 --> 00:03:05.880
William Rosener: that's fine i'm going to go ahead and just simply drag that on down and that's going to compute the age for the remaining employees there.

22
00:03:06.420 --> 00:03:18.570
William Rosener: Let me do one more of these and knowledge to the other one so let's some serve alcohol is 21 a rp eligibility and we've starts at 50 let's do out the serve alcohol.

23
00:03:19.740 --> 00:03:35.910
William Rosener: And we're going to sell its 21 so i'm simply to n equals i'm taking a bath I don't take a look at the age, which is in D two, and if that is greater than or equal to anyone, then on display yes.

24
00:03:37.530 --> 00:03:39.300
William Rosener: Otherwise, to misplay now.

25
00:03:42.330 --> 00:03:45.990
William Rosener: Okay, and since its employees over 21 they can serve up.

26
00:03:47.280 --> 00:04:01.230
William Rosener: i'm now going to go ahead and drag this on down, and we can see we've got one employee and two employees that currently cannot serve alcohol i'm gonna let you others personally they're using the same it there, and this is going to simply be if someone is over 50.

27
00:04:02.730 --> 00:04:10.020
William Rosener: This is going to be the age of the average that would be the average function, the youngest employee that'd be the man i'll let you do that there's.

28
00:04:10.530 --> 00:04:24.750
William Rosener: be the Max function there, let me do one more of these just kind of get you going here, I think this will be the count of function here and I want to get the number employees less than 40 in order to do that i'm used to count the function.

29
00:04:26.160 --> 00:04:38.640
William Rosener: will specify the range, you can see right there soon as I typed account if the parentheses that's can tell me the range and the criteria, the range is going to be D to Colin D seven.

30
00:04:41.160 --> 00:04:49.980
William Rosener: And then I put place the criteria to place that within the double quotes and that's got less than 40.

31
00:04:52.650 --> 00:05:01.050
William Rosener: And the underside so good, how many employees or less than 14 one, two and three okay.

32
00:05:01.920 --> 00:05:11.250
William Rosener: So why don't you go ahead i'll let you finish aarp eligible a couple of performance here for computing the age, the average youngest oldest and this will be very similar here.

33
00:05:11.640 --> 00:05:21.420
William Rosener: which you could even do is first of all calculate aarp eligibility, then you could simply look over here and count the number of yeses and noes.

34
00:05:21.960 --> 00:05:29.820
William Rosener: it'd be another option there well, hopefully in this video you'll learn a little bit about some formulas here and a really, really common one is computing the age.

35
00:05:30.360 --> 00:05:46.200
William Rosener: You never really want to have either a spreadsheet or database with this, because it's so fluid it just keeps changing so what you want to do a store their birthday, then use formula to compute pH there and also introducing a counter function, I guess next video thanks.