WEBVTT

00:02.210 --> 00:03.900
Okay guys welcome back.

00:03.900 --> 00:08.420
Now you can probably guess where we're going to go with this lecture but just for the sake of completeness

00:08.420 --> 00:10.010
we're going to cover it anyway.

00:10.250 --> 00:16.970
Again I've got two rows of numbers here and I'm just going to write a simple formula and say this number

00:17.270 --> 00:19.750
multiplied by this number.

00:19.790 --> 00:28.460
But then I'm going to hit for once and that will give me an absolute absolute one reference and twice.

00:28.580 --> 00:31.730
And now I'm going to get a absolute one.

00:31.730 --> 00:37.850
And what that means is column the column that this formula will look at will vary depending on where

00:37.850 --> 00:39.670
we drag the formula.

00:39.800 --> 00:43.570
But the Rowen number will never move from one.

00:43.580 --> 00:45.800
So what we can do hit enter.

00:46.190 --> 00:52.640
Copy that formula across using control and R and then when we look at this formula by hitting EF 2 we

00:52.640 --> 00:56.840
can see that it's always looking at row 1.

00:56.930 --> 01:01.850
So let's just copy that down a few control and see.

01:01.900 --> 01:03.790
And again we're in some really big numbers.

01:04.130 --> 01:11.270
So if we hit EF 2 now we can see that the B cell the one that's relative relative just straightforward

01:11.420 --> 01:16.590
plain B3 has moved down as we've moved the formula around.

01:16.790 --> 01:20.720
But the second part of the formula be absolute.

01:20.720 --> 01:25.430
One has to change to column B because that's a relative reference.

01:25.430 --> 01:26.660
But it is locked.

01:26.660 --> 01:31.660
So if we come over here and here EF 2 you can see exactly the same thing.

01:31.790 --> 01:34.930
This reference d4 is relative relative.

01:34.940 --> 01:36.590
So whenever we drank the formula.

01:36.620 --> 01:45.320
It is relative to where the formula is looking but day absolute one always looks at row 1 no matter

01:45.380 --> 01:51.380
where you draw the formula because we have the dollar sign in front of the one so that's a relative

01:51.740 --> 01:54.050
absolute cell reference.

01:54.200 --> 01:58.640
Okay I have a play around with it and it will soon become second nature and I'll see you soon.

01:58.640 --> 01:59.700
Thanks very much.
