1
00:00:01,100 --> 00:00:03,730
a local taxes 2013 chat rooms in this

2
00:00:03,730 --> 00:00:07,410
video only showing you how to use T ends at function

3
00:00:07,410 --> 00:00:10,730
along deal function and

4
00:00:10,730 --> 00:00:16,760
so ish wanna play along falling view to don a 6-2 upside down in Texas 2013 TV

5
00:00:16,760 --> 00:00:17,760
59

6
00:00:17,760 --> 00:00:24,760
nation on a okay

7
00:00:26,028 --> 00:00:29,920
side I am in order to understand the

8
00:00:29,920 --> 00:00:33,899
ends it function you can eat understand the deal function

9
00:00:33,899 --> 00:00:38,399
festival

10
00:00:38,399 --> 00:00:41,439
and context what we're trying to do you can try to create

11
00:00:41,439 --> 00:00:47,390
closed at should form she's here

12
00:00:47,390 --> 00:00:50,969
and Gannett's in text boxes here we're going to look up

13
00:00:50,969 --> 00:00:54,808
values in the a table

14
00:00:54,808 --> 00:00:59,070
and table working looking up values in is this will take

15
00:00:59,070 --> 00:01:04,239
was clearly she clearly bookings explode making also questioned this query

16
00:01:04,239 --> 00:01:08,420
for example on the 10th October

17
00:01:08,420 --> 00:01:12,060
in room two one the stair record

18
00:01:12,060 --> 00:01:15,379
soldiers gonna look for tent October

19
00:01:15,379 --> 00:01:22,379
here may have it's not gonna look if it isn't

20
00:01:22,469 --> 00:01:28,090
signed as well and it's going to look for

21
00:01:28,090 --> 00:01:31,680
from numbers were always look for the reminder specifically

22
00:01:31,680 --> 00:01:35,439
Marshall my t-shirt one inside to use

23
00:01:35,438 --> 00:01:38,529
facts number one and each

24
00:01:38,530 --> 00:01:41,989
if finds a record is gonna return

25
00:01:41,989 --> 00:01:46,769
guest here if it doesn't find a record this

26
00:01:46,769 --> 00:01:50,750
fees we're gonna have a problem so its festival tryin

27
00:01:50,750 --> 00:01:55,578
two-year 2d function

28
00:01:55,578 --> 00:01:58,929
K him safe closed at

29
00:01:58,930 --> 00:02:02,710
season there you so go to

30
00:02:02,709 --> 00:02:05,709
design and shoes

31
00:02:05,709 --> 00:02:09,159
text books strip for textbooks in anger

32
00:02:09,159 --> 00:02:12,669
label and

33
00:02:12,669 --> 00:02:16,280
rename this

34
00:02:16,280 --> 00:02:20,870
text 80 hours

35
00:02:20,870 --> 00:02:27,870
text 0 suppose list

36
00:02:30,759 --> 00:02:34,409
such three

37
00:02:34,409 --> 00:02:37,629
she's text long

38
00:02:37,629 --> 00:02:44,460
and text to

39
00:02:44,460 --> 00:02:51,460
okie dokie right gonna be copping a functional previously safe week

40
00:02:52,000 --> 00:02:55,889
on going to be tricky you know if

41
00:02:55,889 --> 00:02:59,679
format every time we get a data to come here

42
00:02:59,680 --> 00:03:02,770
first equals Andy

43
00:03:02,770 --> 00:03:07,390
an opportunist looking up guest Inc revoking exploded wherever mighty

44
00:03:07,389 --> 00:03:10,579
who's from it. and the day

45
00:03:10,580 --> 00:03:13,700
&gt whose converting

46
00:03:13,699 --> 00:03:17,339
day plus and 0 de makes some sense

47
00:03:17,340 --> 00:03:20,849
known sure from too many

48
00:03:20,849 --> 00:03:26,509
closing back use this is one 40 star Swan

49
00:03:26,509 --> 00:03:29,509
to use

50
00:03:29,509 --> 00:03:33,179
Surrey to one

51
00:03:33,180 --> 00:03:40,180
Journal Sr but the press OK see what happens

52
00:03:43,789 --> 00:03:49,870
that's interesting

53
00:03:49,870 --> 00:03:53,090
which is actually returning to correct name in certain instances

54
00:03:53,090 --> 00:03:57,080
as expected to return an error only returns an error if you doing

55
00:03:57,080 --> 00:04:01,340
must be 2013 it on something other era us to the new

56
00:04:01,340 --> 00:04:04,939
change rid of okay learn something new everyday

57
00:04:04,939 --> 00:04:08,069
okay first less them make

58
00:04:08,069 --> 00:04:11,930
just texted smaller so you want something condensed

59
00:04:11,930 --> 00:04:16,478
be nice

60
00:04:16,478 --> 00:04:23,478
Twitter

61
00:04:32,319 --> 00:04:36,629
from okay to go to pick up two things

62
00:04:36,629 --> 00:04:41,180
festival one Minister designed you

63
00:04:41,180 --> 00:04:44,829
coat to you she's creep expert a good guest

64
00:04:44,829 --> 00:04:48,228
and went over to do first time in the last thing

65
00:04:48,228 --> 00:04:52,360
left take a guess first name common one

66
00:04:52,360 --> 00:04:56,509
so it's gonna be returned in the first letter VTI lost nine

67
00:04:56,509 --> 00:04:59,889
eisner 5

68
00:04:59,889 --> 00:05:03,250
jameson

69
00:05:03,250 --> 00:05:08,750
shoreline I was kinda random are traded pixels kinda hoping for massive air is

70
00:05:08,750 --> 00:05:09,560
coming up here

71
00:05:09,560 --> 00:05:12,600
but his deal

72
00:05:12,600 --> 00:05:16,470
at the moment still kinda relevant we've got the name being returned

73
00:05:16,470 --> 00:05:20,000
finds a record which it does and we've got basically no thousand

74
00:05:20,000 --> 00:05:23,589
actually if it does in by

75
00:05:23,589 --> 00:05:28,209
Ste knows gonna Sastre want to

76
00:05:28,209 --> 00:05:31,339
value in now -1

77
00:05:31,339 --> 00:05:36,969
I was kinda got due to this is the this is a video about the ends at function

78
00:05:36,970 --> 00:05:38,039
centre is a day

79
00:05:38,038 --> 00:05:41,829
before the delight of you type in and said

80
00:05:41,829 --> 00:05:45,319
and then bracket and after up

81
00:05:45,319 --> 00:05:49,500
comma -1 bracket what it does is it says

82
00:05:49,500 --> 00:05:52,538
dysfunction hey which is the dealer cost function

83
00:05:52,538 --> 00:05:56,509
that needs to return a value it returns no

84
00:05:56,509 --> 00:06:00,949
we're gonna put this valued and the value we put in if it returns no

85
00:06:00,949 --> 00:06:05,150
community -1 scored a good option Free Press okay now

86
00:06:05,149 --> 00:06:08,769
you cedar unlike

87
00:06:08,769 --> 00:06:13,359
some reason to use either the anytime is fine to record returns name

88
00:06:13,360 --> 00:06:17,379
anytime it doesn't find a recorder returns -1

89
00:06:17,379 --> 00:06:21,069
okay that's what you need to any

90
00:06:21,069 --> 00:06:25,050
take this control C

91
00:06:25,050 --> 00:06:29,918
gonna go to the next text books truck in there

92
00:06:29,918 --> 00:06:33,689
mighty an energy

93
00:06:33,689 --> 00:06:39,709
just change it 1

94
00:06:39,709 --> 00:06:41,259
K

95
00:06:41,259 --> 00:06:44,289
so we're going to do now is on and work my way

96
00:06:44,290 --> 00:06:49,050
long the former

97
00:06:49,050 --> 00:06:55,850
changes work my way along D

98
00:06:55,850 --> 00:06:59,160
writing textbooks and adding

99
00:06:59,160 --> 00:07:03,480
same and India

100
00:07:03,480 --> 00:07:07,400
function on scanner increment this value one every single time

101
00:07:07,399 --> 00:07:10,739
so much can pause the video so I can show you in done everything

102
00:07:10,740 --> 00:07:14,610
sexy in two seconds Okies

103
00:07:14,610 --> 00:07:17,939
have done that Paso chain

104
00:07:17,939 --> 00:07:21,230
go down CNN's go as we have

105
00:07:21,230 --> 00:07:24,430
missed jameson

106
00:07:24,430 --> 00:07:28,310
seems to be everywhere I'm I am

107
00:07:28,310 --> 00:07:32,069
yet where we've got a guest recalled

108
00:07:32,069 --> 00:07:37,699
we get the name as a guest where we have my record so we get -1

109
00:07:37,699 --> 00:07:42,089
nothing I could have done it which shows a guest and then

110
00:07:42,089 --> 00:07:46,379
no I am fucked

111
00:07:46,379 --> 00:07:52,949
I decided to do it this way breezes which will come

112
00:07:52,949 --> 00:07:57,620
parent in the next video a so 10 single do actually

113
00:07:57,620 --> 00:08:00,649
now go to form

114
00:08:00,649 --> 00:08:05,529
and

115
00:08:05,529 --> 00:08:10,039
to see data and lower additions actually

116
00:08:10,040 --> 00:08:15,910
tuition

117
00:08:15,910 --> 00:08:18,479
okie dokie said asap so what is the ends its function do

118
00:08:18,478 --> 00:08:22,329
when used deal function to return a value if

119
00:08:22,329 --> 00:08:26,750
you can't find Valley to return returns a null value which

120
00:08:26,750 --> 00:08:30,930
policy previous taxes 2013 actually generate an error

121
00:08:30,930 --> 00:08:36,940
there was a change that now Barack you can use and ends at

122
00:08:36,940 --> 00:08:40,190
yourself anyway and decide on the value

123
00:08:40,190 --> 00:08:44,540
it's been returned stay one last look at showing so ended looks up

124
00:08:44,539 --> 00:08:48,610
that so dear Cup get step

125
00:08:48,610 --> 00:08:51,930
values that value returns no is nothing there

126
00:08:51,929 --> 00:08:55,179
which I went okay give us a -1 instead STI

127
00:08:55,179 --> 00:08:59,269
necessary nothing more to say about it forbes

128
00:08:59,269 --> 00:09:03,299
okay say thanks for watching a and have seen the next video

129
00:09:03,299 --> 00:09:05,329
will be doing some conditional formatting