WEBVTT
Kind: captions
Language: en

00:00:00.900 --> 00:00:03.070 align:start position:0%
 
you<00:00:01.589><c> may</c><00:00:01.829><c> already</c><00:00:02.159><c> have</c><00:00:02.460><c> some</c><00:00:02.850><c> experience</c>

00:00:03.070 --> 00:00:03.080 align:start position:0%
you may already have some experience
 

00:00:03.080 --> 00:00:05.960 align:start position:0%
you may already have some experience
creating<00:00:04.080><c> simple</c><00:00:04.470><c> formulas</c><00:00:05.070><c> that</c><00:00:05.100><c> have</c><00:00:05.430><c> only</c>

00:00:05.960 --> 00:00:05.970 align:start position:0%
creating simple formulas that have only
 

00:00:05.970 --> 00:00:09.020 align:start position:0%
creating simple formulas that have only
one<00:00:06.210><c> type</c><00:00:06.480><c> of</c><00:00:06.509><c> operation</c><00:00:07.189><c> but</c><00:00:08.189><c> sometimes</c><00:00:08.790><c> you</c>

00:00:09.020 --> 00:00:09.030 align:start position:0%
one type of operation but sometimes you
 

00:00:09.030 --> 00:00:11.029 align:start position:0%
one type of operation but sometimes you
have<00:00:09.209><c> to</c><00:00:09.360><c> create</c><00:00:09.509><c> more</c><00:00:09.870><c> complex</c><00:00:10.289><c> formulas</c>

00:00:11.029 --> 00:00:11.039 align:start position:0%
have to create more complex formulas
 

00:00:11.039 --> 00:00:13.549 align:start position:0%
have to create more complex formulas
that<00:00:11.339><c> do</c><00:00:11.549><c> have</c><00:00:11.759><c> more</c><00:00:11.940><c> than</c><00:00:11.999><c> one</c><00:00:12.299><c> Operator</c><00:00:12.869><c> for</c>

00:00:13.549 --> 00:00:13.559 align:start position:0%
that do have more than one Operator for
 

00:00:13.559 --> 00:00:16.790 align:start position:0%
that do have more than one Operator for
example<00:00:14.099><c> addition</c><00:00:14.820><c> and</c><00:00:15.059><c> multiplication</c><00:00:15.800><c> to</c>

00:00:16.790 --> 00:00:16.800 align:start position:0%
example addition and multiplication to
 

00:00:16.800 --> 00:00:18.769 align:start position:0%
example addition and multiplication to
do<00:00:16.980><c> this</c><00:00:17.189><c> you'll</c><00:00:17.670><c> need</c><00:00:17.759><c> to</c><00:00:17.910><c> understand</c><00:00:18.599><c> how</c>

00:00:18.769 --> 00:00:18.779 align:start position:0%
do this you'll need to understand how
 

00:00:18.779 --> 00:00:21.070 align:start position:0%
do this you'll need to understand how
Google<00:00:19.199><c> sheets</c><00:00:19.500><c> is</c><00:00:19.740><c> calculating</c><00:00:20.519><c> the</c><00:00:20.670><c> answer</c>

00:00:21.070 --> 00:00:21.080 align:start position:0%
Google sheets is calculating the answer
 

00:00:21.080 --> 00:00:23.839 align:start position:0%
Google sheets is calculating the answer
Google<00:00:22.080><c> sheets</c><00:00:22.410><c> uses</c><00:00:22.859><c> a</c><00:00:22.890><c> set</c><00:00:23.220><c> of</c><00:00:23.339><c> rules</c><00:00:23.580><c> called</c>

00:00:23.839 --> 00:00:23.849 align:start position:0%
Google sheets uses a set of rules called
 

00:00:23.849 --> 00:00:26.570 align:start position:0%
Google sheets uses a set of rules called
the<00:00:24.210><c> order</c><00:00:24.570><c> of</c><00:00:24.779><c> operations</c><00:00:25.560><c> which</c><00:00:26.189><c> you</c><00:00:26.400><c> might</c>

00:00:26.570 --> 00:00:26.580 align:start position:0%
the order of operations which you might
 

00:00:26.580 --> 00:00:29.239 align:start position:0%
the order of operations which you might
remember<00:00:26.939><c> from</c><00:00:27.089><c> math</c><00:00:27.449><c> class</c><00:00:27.710><c> the</c><00:00:28.710><c> order</c><00:00:29.070><c> of</c>

00:00:29.239 --> 00:00:29.249 align:start position:0%
remember from math class the order of
 

00:00:29.249 --> 00:00:31.489 align:start position:0%
remember from math class the order of
operations<00:00:29.970><c> determines</c><00:00:30.660><c> which</c><00:00:30.900><c> parts</c><00:00:31.320><c> of</c><00:00:31.439><c> the</c>

00:00:31.489 --> 00:00:31.499 align:start position:0%
operations determines which parts of the
 

00:00:31.499 --> 00:00:34.340 align:start position:0%
operations determines which parts of the
formula<00:00:31.589><c> to</c><00:00:32.279><c> calculate</c><00:00:32.310><c> first</c><00:00:33.060><c> the</c><00:00:34.020><c> very</c>

00:00:34.340 --> 00:00:34.350 align:start position:0%
formula to calculate first the very
 

00:00:34.350 --> 00:00:36.260 align:start position:0%
formula to calculate first the very
first<00:00:34.680><c> thing</c><00:00:35.010><c> that</c><00:00:35.040><c> you</c><00:00:35.220><c> calculate</c><00:00:35.910><c> are</c><00:00:36.120><c> the</c>

00:00:36.260 --> 00:00:36.270 align:start position:0%
first thing that you calculate are the
 

00:00:36.270 --> 00:00:39.290 align:start position:0%
first thing that you calculate are the
items<00:00:36.420><c> in</c><00:00:36.870><c> parentheses</c><00:00:37.650><c> then</c><00:00:38.550><c> if</c><00:00:38.880><c> you</c><00:00:39.090><c> have</c>

00:00:39.290 --> 00:00:39.300 align:start position:0%
items in parentheses then if you have
 

00:00:39.300 --> 00:00:41.590 align:start position:0%
items in parentheses then if you have
any<00:00:39.420><c> exponents</c><00:00:39.870><c> you'll</c><00:00:40.500><c> calculate</c><00:00:40.740><c> those</c>

00:00:41.590 --> 00:00:41.600 align:start position:0%
any exponents you'll calculate those
 

00:00:41.600 --> 00:00:44.410 align:start position:0%
any exponents you'll calculate those
next<00:00:42.600><c> is</c><00:00:42.780><c> multiplication</c><00:00:43.440><c> and</c><00:00:43.710><c> division</c><00:00:44.190><c> and</c>

00:00:44.410 --> 00:00:44.420 align:start position:0%
next is multiplication and division and
 

00:00:44.420 --> 00:00:47.900 align:start position:0%
next is multiplication and division and
finally<00:00:45.420><c> addition</c><00:00:45.870><c> and</c><00:00:46.260><c> subtraction</c><00:00:47.100><c> your</c>

00:00:47.900 --> 00:00:47.910 align:start position:0%
finally addition and subtraction your
 

00:00:47.910 --> 00:00:49.640 align:start position:0%
finally addition and subtraction your
spreadsheet<00:00:48.540><c> knows</c><00:00:48.810><c> how</c><00:00:48.990><c> to</c><00:00:49.050><c> use</c><00:00:49.140><c> the</c><00:00:49.470><c> order</c>

00:00:49.640 --> 00:00:49.650 align:start position:0%
spreadsheet knows how to use the order
 

00:00:49.650 --> 00:00:51.770 align:start position:0%
spreadsheet knows how to use the order
of<00:00:49.770><c> operations</c><00:00:50.010><c> whenever</c><00:00:50.820><c> it</c><00:00:51.120><c> calculates</c><00:00:51.630><c> a</c>

00:00:51.770 --> 00:00:51.780 align:start position:0%
of operations whenever it calculates a
 

00:00:51.780 --> 00:00:54.080 align:start position:0%
of operations whenever it calculates a
complex<00:00:52.230><c> formula</c><00:00:52.770><c> it's</c><00:00:53.310><c> important</c><00:00:53.790><c> that</c><00:00:53.850><c> you</c>

00:00:54.080 --> 00:00:54.090 align:start position:0%
complex formula it's important that you
 

00:00:54.090 --> 00:00:56.090 align:start position:0%
complex formula it's important that you
remember<00:00:54.270><c> it</c><00:00:54.660><c> so</c><00:00:54.930><c> you</c><00:00:54.990><c> can</c><00:00:55.290><c> create</c><00:00:55.410><c> formulas</c>

00:00:56.090 --> 00:00:56.100 align:start position:0%
remember it so you can create formulas
 

00:00:56.100 --> 00:00:58.490 align:start position:0%
remember it so you can create formulas
that'll<00:00:56.430><c> give</c><00:00:56.610><c> you</c><00:00:56.730><c> the</c><00:00:56.880><c> correct</c><00:00:57.150><c> answer</c><00:00:57.500><c> to</c>

00:00:58.490 --> 00:00:58.500 align:start position:0%
that'll give you the correct answer to
 

00:00:58.500 --> 00:01:00.380 align:start position:0%
that'll give you the correct answer to
remember<00:00:58.890><c> the</c><00:00:59.010><c> order</c><00:00:59.190><c> you</c><00:00:59.640><c> can</c><00:00:59.820><c> just</c><00:01:00.030><c> use</c><00:01:00.210><c> the</c>

00:01:00.380 --> 00:01:00.390 align:start position:0%
remember the order you can just use the
 

00:01:00.390 --> 00:01:03.500 align:start position:0%
remember the order you can just use the
acronym<00:01:00.620><c> PEMDAS</c><00:01:01.620><c> or</c><00:01:02.190><c> to</c><00:01:02.850><c> make</c><00:01:03.000><c> it</c><00:01:03.030><c> even</c><00:01:03.210><c> easier</c>

00:01:03.500 --> 00:01:03.510 align:start position:0%
acronym PEMDAS or to make it even easier
 

00:01:03.510 --> 00:01:06.560 align:start position:0%
acronym PEMDAS or to make it even easier
remember<00:01:04.290><c> the</c><00:01:04.530><c> phrase</c><00:01:04.769><c> please</c><00:01:05.700><c> excuse</c><00:01:06.360><c> my</c>

00:01:06.560 --> 00:01:06.570 align:start position:0%
remember the phrase please excuse my
 

00:01:06.570 --> 00:01:09.230 align:start position:0%
remember the phrase please excuse my
dear<00:01:06.600><c> Aunt</c><00:01:07.080><c> Sally</c><00:01:07.460><c> let's</c><00:01:08.460><c> go</c><00:01:08.640><c> over</c><00:01:08.940><c> each</c><00:01:09.180><c> of</c>

00:01:09.230 --> 00:01:09.240 align:start position:0%
dear Aunt Sally let's go over each of
 

00:01:09.240 --> 00:01:12.140 align:start position:0%
dear Aunt Sally let's go over each of
these<00:01:09.570><c> in</c><00:01:09.630><c> a</c><00:01:10.050><c> little</c><00:01:10.200><c> more</c><00:01:10.320><c> detail</c>

00:01:12.140 --> 00:01:12.150 align:start position:0%
these in a little more detail
 

00:01:12.150 --> 00:01:15.020 align:start position:0%
these in a little more detail
in<00:01:12.210><c> this</c><00:01:12.720><c> formula</c><00:01:13.290><c> five</c><00:01:13.800><c> plus</c><00:01:14.220><c> two</c><00:01:14.520><c> is</c><00:01:14.550><c> in</c>

00:01:15.020 --> 00:01:15.030 align:start position:0%
in this formula five plus two is in
 

00:01:15.030 --> 00:01:17.750 align:start position:0%
in this formula five plus two is in
parentheses<00:01:15.800><c> so</c><00:01:16.800><c> we'll</c><00:01:16.980><c> calculate</c><00:01:17.250><c> that</c>

00:01:17.750 --> 00:01:17.760 align:start position:0%
parentheses so we'll calculate that
 

00:01:17.760 --> 00:01:20.690 align:start position:0%
parentheses so we'll calculate that
first<00:01:18.180><c> to</c><00:01:18.630><c> get</c><00:01:18.810><c> seven</c><00:01:19.200><c> and</c><00:01:19.410><c> then</c><00:01:20.220><c> we</c><00:01:20.370><c> can</c><00:01:20.520><c> just</c>

00:01:20.690 --> 00:01:20.700 align:start position:0%
first to get seven and then we can just
 

00:01:20.700 --> 00:01:25.190 align:start position:0%
first to get seven and then we can just
multiply<00:01:20.810><c> three</c><00:01:21.810><c> times</c><00:01:21.840><c> seven</c><00:01:22.410><c> to</c><00:01:22.890><c> get</c><00:01:23.070><c> 21</c>

00:01:25.190 --> 00:01:25.200 align:start position:0%
multiply three times seven to get 21
 

00:01:25.200 --> 00:01:29.480 align:start position:0%
multiply three times seven to get 21
this<00:01:25.680><c> formula</c><00:01:26.189><c> contains</c><00:01:26.400><c> an</c><00:01:26.880><c> exponent</c><00:01:27.450><c> 3</c><00:01:28.320><c> ^</c><00:01:28.650><c> 2</c>

00:01:29.480 --> 00:01:29.490 align:start position:0%
this formula contains an exponent 3 ^ 2
 

00:01:29.490 --> 00:01:31.789 align:start position:0%
this formula contains an exponent 3 ^ 2
we'll<00:01:30.390><c> need</c><00:01:30.570><c> to</c><00:01:30.720><c> calculate</c><00:01:31.259><c> that</c><00:01:31.439><c> first</c>

00:01:31.789 --> 00:01:31.799 align:start position:0%
we'll need to calculate that first
 

00:01:31.799 --> 00:01:34.590 align:start position:0%
we'll need to calculate that first
before<00:01:32.159><c> doing</c><00:01:32.400><c> the</c><00:01:32.880><c> addition</c>

00:01:34.590 --> 00:01:34.600 align:start position:0%
before doing the addition
 

00:01:34.600 --> 00:01:37.020 align:start position:0%
before doing the addition
if<00:01:34.659><c> you</c><00:01:35.170><c> have</c><00:01:35.380><c> multiplication</c><00:01:36.250><c> or</c><00:01:36.400><c> division</c>

00:01:37.020 --> 00:01:37.030 align:start position:0%
if you have multiplication or division
 

00:01:37.030 --> 00:01:40.200 align:start position:0%
if you have multiplication or division
that'll<00:01:37.390><c> come</c><00:01:37.600><c> next</c><00:01:38.369><c> here</c><00:01:39.369><c> we</c><00:01:39.670><c> multiply</c><00:01:40.150><c> 2</c>

00:01:40.200 --> 00:01:40.210 align:start position:0%
that'll come next here we multiply 2
 

00:01:40.210 --> 00:01:45.260 align:start position:0%
that'll come next here we multiply 2
times<00:01:40.600><c> 4</c><00:01:41.320><c> to</c><00:01:41.650><c> get</c><00:01:41.799><c> 8</c><00:01:42.070><c> and</c><00:01:42.390><c> 9</c><00:01:43.390><c> minus</c><00:01:43.659><c> 8</c><00:01:44.049><c> equals</c><00:01:44.380><c> 1</c>

00:01:45.260 --> 00:01:45.270 align:start position:0%
times 4 to get 8 and 9 minus 8 equals 1
 

00:01:45.270 --> 00:01:47.850 align:start position:0%
times 4 to get 8 and 9 minus 8 equals 1
now<00:01:46.270><c> multiplication</c><00:01:47.140><c> and</c><00:01:47.259><c> division</c><00:01:47.710><c> are</c>

00:01:47.850 --> 00:01:47.860 align:start position:0%
now multiplication and division are
 

00:01:47.860 --> 00:01:49.770 align:start position:0%
now multiplication and division are
considered<00:01:48.399><c> to</c><00:01:48.580><c> be</c><00:01:48.729><c> at</c><00:01:48.850><c> the</c><00:01:48.880><c> same</c><00:01:49.180><c> level</c><00:01:49.630><c> that</c>

00:01:49.770 --> 00:01:49.780 align:start position:0%
considered to be at the same level that
 

00:01:49.780 --> 00:01:51.810 align:start position:0%
considered to be at the same level that
means<00:01:50.439><c> if</c><00:01:50.680><c> you</c><00:01:50.830><c> have</c><00:01:50.860><c> both</c><00:01:51.250><c> of</c><00:01:51.280><c> them</c><00:01:51.580><c> in</c><00:01:51.640><c> your</c>

00:01:51.810 --> 00:01:51.820 align:start position:0%
means if you have both of them in your
 

00:01:51.820 --> 00:01:54.359 align:start position:0%
means if you have both of them in your
formula<00:01:52.149><c> they're</c><00:01:52.780><c> calculated</c><00:01:53.530><c> from</c><00:01:53.799><c> left</c><00:01:54.070><c> to</c>

00:01:54.359 --> 00:01:54.369 align:start position:0%
formula they're calculated from left to
 

00:01:54.369 --> 00:01:56.910 align:start position:0%
formula they're calculated from left to
right<00:01:54.789><c> in</c><00:01:55.000><c> this</c><00:01:55.750><c> example</c><00:01:56.140><c> we'll</c><00:01:56.530><c> do</c><00:01:56.740><c> the</c>

00:01:56.910 --> 00:01:56.920 align:start position:0%
right in this example we'll do the
 

00:01:56.920 --> 00:01:59.010 align:start position:0%
right in this example we'll do the
division<00:01:57.190><c> first</c><00:01:57.399><c> and</c><00:01:58.000><c> then</c><00:01:58.869><c> the</c>

00:01:59.010 --> 00:01:59.020 align:start position:0%
division first and then the
 

00:01:59.020 --> 00:02:01.020 align:start position:0%
division first and then the
multiplication

00:02:01.020 --> 00:02:01.030 align:start position:0%
multiplication
 

00:02:01.030 --> 00:02:02.880 align:start position:0%
multiplication
if<00:02:01.090><c> we</c><00:02:01.630><c> wanted</c><00:02:01.900><c> the</c><00:02:02.020><c> multiplication</c><00:02:02.049><c> to</c>

00:02:02.880 --> 00:02:02.890 align:start position:0%
if we wanted the multiplication to
 

00:02:02.890 --> 00:02:05.070 align:start position:0%
if we wanted the multiplication to
happen<00:02:03.220><c> first</c><00:02:03.580><c> we</c><00:02:04.150><c> could</c><00:02:04.330><c> just</c><00:02:04.540><c> put</c><00:02:04.810><c> it</c><00:02:04.930><c> in</c>

00:02:05.070 --> 00:02:05.080 align:start position:0%
happen first we could just put it in
 

00:02:05.080 --> 00:02:07.649 align:start position:0%
happen first we could just put it in
parentheses<00:02:05.770><c> or</c><00:02:06.310><c> we</c><00:02:06.850><c> could</c><00:02:07.060><c> rearrange</c><00:02:07.360><c> the</c>

00:02:07.649 --> 00:02:07.659 align:start position:0%
parentheses or we could rearrange the
 

00:02:07.659 --> 00:02:09.930 align:start position:0%
parentheses or we could rearrange the
formula<00:02:07.960><c> so</c><00:02:08.500><c> the</c><00:02:08.619><c> multiplication</c><00:02:09.399><c> was</c><00:02:09.610><c> on</c><00:02:09.789><c> the</c>

00:02:09.930 --> 00:02:09.940 align:start position:0%
formula so the multiplication was on the
 

00:02:09.940 --> 00:02:11.510 align:start position:0%
formula so the multiplication was on the
left

00:02:11.510 --> 00:02:11.520 align:start position:0%
left
 

00:02:11.520 --> 00:02:14.550 align:start position:0%
left
finally<00:02:12.520><c> we</c><00:02:12.880><c> have</c><00:02:13.030><c> addition</c><00:02:13.540><c> and</c><00:02:13.750><c> subtraction</c>

00:02:14.550 --> 00:02:14.560 align:start position:0%
finally we have addition and subtraction
 

00:02:14.560 --> 00:02:17.220 align:start position:0%
finally we have addition and subtraction
just<00:02:14.740><c> like</c><00:02:15.580><c> multiplication</c><00:02:16.510><c> and</c><00:02:16.690><c> division</c>

00:02:17.220 --> 00:02:17.230 align:start position:0%
just like multiplication and division
 

00:02:17.230 --> 00:02:19.440 align:start position:0%
just like multiplication and division
these<00:02:17.380><c> are</c><00:02:17.800><c> on</c><00:02:17.950><c> the</c><00:02:18.070><c> same</c><00:02:18.310><c> level</c><00:02:18.580><c> so</c><00:02:19.270><c> we'll</c>

00:02:19.440 --> 00:02:19.450 align:start position:0%
these are on the same level so we'll
 

00:02:19.450 --> 00:02:23.510 align:start position:0%
these are on the same level so we'll
calculate<00:02:19.690><c> them</c><00:02:20.260><c> from</c><00:02:20.590><c> left</c><00:02:20.860><c> to</c><00:02:21.160><c> right</c>

00:02:23.510 --> 00:02:23.520 align:start position:0%
calculate them from left to right
 

00:02:23.520 --> 00:02:25.790 align:start position:0%
calculate them from left to right
now<00:02:23.730><c> let's</c><00:02:23.970><c> put</c><00:02:24.180><c> them</c><00:02:24.330><c> all</c><00:02:24.510><c> together</c><00:02:24.800><c> this</c>

00:02:25.790 --> 00:02:25.800 align:start position:0%
now let's put them all together this
 

00:02:25.800 --> 00:02:28.280 align:start position:0%
now let's put them all together this
formula<00:02:26.400><c> may</c><00:02:26.640><c> look</c><00:02:26.850><c> really</c><00:02:27.210><c> complicated</c><00:02:27.420><c> but</c>

00:02:28.280 --> 00:02:28.290 align:start position:0%
formula may look really complicated but
 

00:02:28.290 --> 00:02:29.930 align:start position:0%
formula may look really complicated but
we're<00:02:28.530><c> just</c><00:02:28.560><c> going</c><00:02:29.010><c> to</c><00:02:29.040><c> go</c><00:02:29.250><c> step</c><00:02:29.640><c> by</c><00:02:29.700><c> step</c>

00:02:29.930 --> 00:02:29.940 align:start position:0%
we're just going to go step by step
 

00:02:29.940 --> 00:02:32.060 align:start position:0%
we're just going to go step by step
through<00:02:30.510><c> the</c><00:02:30.630><c> order</c><00:02:30.930><c> of</c><00:02:31.080><c> operations</c><00:02:31.800><c> and</c>

00:02:32.060 --> 00:02:32.070 align:start position:0%
through the order of operations and
 

00:02:32.070 --> 00:02:34.190 align:start position:0%
through the order of operations and
you'll<00:02:32.400><c> see</c><00:02:32.640><c> that</c><00:02:32.820><c> it's</c><00:02:32.970><c> really</c><00:02:33.180><c> not</c><00:02:33.420><c> that</c><00:02:33.660><c> bad</c>

00:02:34.190 --> 00:02:34.200 align:start position:0%
you'll see that it's really not that bad
 

00:02:34.200 --> 00:02:37.100 align:start position:0%
you'll see that it's really not that bad
we'll<00:02:35.010><c> start</c><00:02:35.310><c> with</c><00:02:35.460><c> the</c><00:02:35.580><c> parentheses</c><00:02:36.110><c> we'll</c>

00:02:37.100 --> 00:02:37.110 align:start position:0%
we'll start with the parentheses we'll
 

00:02:37.110 --> 00:02:39.290 align:start position:0%
we'll start with the parentheses we'll
calculate<00:02:37.320><c> each</c><00:02:37.890><c> of</c><00:02:37.920><c> these</c><00:02:38.220><c> to</c><00:02:38.550><c> get</c><00:02:38.700><c> two</c><00:02:39.000><c> and</c>

00:02:39.290 --> 00:02:39.300 align:start position:0%
calculate each of these to get two and
 

00:02:39.300 --> 00:02:42.680 align:start position:0%
calculate each of these to get two and
three<00:02:39.960><c> and</c><00:02:40.230><c> as</c><00:02:41.010><c> you</c><00:02:41.250><c> can</c><00:02:41.460><c> see</c><00:02:41.700><c> the</c><00:02:42.120><c> formula</c><00:02:42.630><c> is</c>

00:02:42.680 --> 00:02:42.690 align:start position:0%
three and as you can see the formula is
 

00:02:42.690 --> 00:02:45.160 align:start position:0%
three and as you can see the formula is
already<00:02:43.230><c> starting</c><00:02:43.710><c> to</c><00:02:43.740><c> look</c><00:02:43.980><c> a</c><00:02:44.130><c> bit</c><00:02:44.160><c> simpler</c>

00:02:45.160 --> 00:02:45.170 align:start position:0%
already starting to look a bit simpler
 

00:02:45.170 --> 00:02:47.600 align:start position:0%
already starting to look a bit simpler
next<00:02:46.170><c> we'll</c><00:02:46.500><c> look</c><00:02:46.710><c> to</c><00:02:46.950><c> see</c><00:02:46.980><c> if</c><00:02:47.310><c> there</c><00:02:47.490><c> are</c><00:02:47.520><c> any</c>

00:02:47.600 --> 00:02:47.610 align:start position:0%
next we'll look to see if there are any
 

00:02:47.610 --> 00:02:50.270 align:start position:0%
next we'll look to see if there are any
exponents<00:02:48.030><c> in</c><00:02:48.630><c> this</c><00:02:48.780><c> formula</c><00:02:49.290><c> and</c><00:02:49.470><c> there</c><00:02:50.160><c> is</c>

00:02:50.270 --> 00:02:50.280 align:start position:0%
exponents in this formula and there is
 

00:02:50.280 --> 00:02:53.510 align:start position:0%
exponents in this formula and there is
one<00:02:50.580><c> two</c><00:02:51.360><c> to</c><00:02:51.840><c> the</c><00:02:51.960><c> second</c><00:02:52.350><c> power</c><00:02:52.400><c> when</c><00:02:53.400><c> we</c>

00:02:53.510 --> 00:02:53.520 align:start position:0%
one two to the second power when we
 

00:02:53.520 --> 00:02:56.660 align:start position:0%
one two to the second power when we
calculate<00:02:54.060><c> it</c><00:02:54.210><c> it</c><00:02:54.390><c> becomes</c><00:02:54.840><c> four</c><00:02:55.430><c> next</c><00:02:56.430><c> we'll</c>

00:02:56.660 --> 00:02:56.670 align:start position:0%
calculate it it becomes four next we'll
 

00:02:56.670 --> 00:02:58.820 align:start position:0%
calculate it it becomes four next we'll
do<00:02:56.820><c> the</c><00:02:56.850><c> multiplication</c><00:02:56.970><c> and</c><00:02:57.840><c> division</c><00:02:58.350><c> going</c>

00:02:58.820 --> 00:02:58.830 align:start position:0%
do the multiplication and division going
 

00:02:58.830 --> 00:03:01.440 align:start position:0%
do the multiplication and division going
from<00:02:59.100><c> left</c><00:02:59.370><c> to</c><00:02:59.670><c> right</c>

00:03:01.440 --> 00:03:01.450 align:start position:0%
from left to right
 

00:03:01.450 --> 00:03:03.510 align:start position:0%
from left to right
and<00:03:01.540><c> now</c><00:03:01.959><c> all</c><00:03:02.170><c> that's</c><00:03:02.349><c> left</c><00:03:02.680><c> is</c><00:03:02.860><c> addition</c><00:03:03.400><c> and</c>

00:03:03.510 --> 00:03:03.520 align:start position:0%
and now all that's left is addition and
 

00:03:03.520 --> 00:03:06.210 align:start position:0%
and now all that's left is addition and
that<00:03:03.610><c> gives</c><00:03:04.390><c> us</c><00:03:04.569><c> our</c><00:03:04.720><c> answer</c><00:03:04.780><c> which</c><00:03:05.739><c> is</c><00:03:05.769><c> eight</c>

00:03:06.210 --> 00:03:06.220 align:start position:0%
that gives us our answer which is eight
 

00:03:06.220 --> 00:03:08.729 align:start position:0%
that gives us our answer which is eight
point<00:03:06.640><c> seven</c><00:03:06.910><c> five</c><00:03:07.269><c> and</c><00:03:07.569><c> that's</c><00:03:08.260><c> the</c><00:03:08.500><c> same</c>

00:03:08.729 --> 00:03:08.739 align:start position:0%
point seven five and that's the same
 

00:03:08.739 --> 00:03:10.619 align:start position:0%
point seven five and that's the same
answer<00:03:09.010><c> Google</c><00:03:09.610><c> sheets</c><00:03:09.910><c> would</c><00:03:10.120><c> give</c><00:03:10.300><c> you</c><00:03:10.450><c> if</c>

00:03:10.619 --> 00:03:10.629 align:start position:0%
answer Google sheets would give you if
 

00:03:10.629 --> 00:03:12.059 align:start position:0%
answer Google sheets would give you if
you<00:03:10.870><c> entered</c><00:03:11.230><c> the</c><00:03:11.349><c> formula</c><00:03:11.830><c> in</c><00:03:12.010><c> your</c>

00:03:12.059 --> 00:03:12.069 align:start position:0%
you entered the formula in your
 

00:03:12.069 --> 00:03:14.080 align:start position:0%
you entered the formula in your
spreadsheet

00:03:14.080 --> 00:03:14.090 align:start position:0%
spreadsheet
 

00:03:14.090 --> 00:03:16.180 align:start position:0%
spreadsheet
it's<00:03:14.660><c> important</c><00:03:15.200><c> to</c><00:03:15.290><c> keep</c><00:03:15.470><c> these</c><00:03:15.650><c> rules</c><00:03:15.920><c> in</c>

00:03:16.180 --> 00:03:16.190 align:start position:0%
it's important to keep these rules in
 

00:03:16.190 --> 00:03:17.890 align:start position:0%
it's important to keep these rules in
mind<00:03:16.430><c> whenever</c><00:03:16.700><c> you're</c><00:03:16.940><c> creating</c><00:03:17.239><c> a</c><00:03:17.599><c> formula</c>

00:03:17.890 --> 00:03:17.900 align:start position:0%
mind whenever you're creating a formula
 

00:03:17.900 --> 00:03:20.350 align:start position:0%
mind whenever you're creating a formula
in<00:03:18.290><c> this</c><00:03:18.800><c> example</c><00:03:19.190><c> I'd</c><00:03:19.550><c> like</c><00:03:19.610><c> to</c><00:03:19.879><c> add</c><00:03:20.000><c> these</c>

00:03:20.350 --> 00:03:20.360 align:start position:0%
in this example I'd like to add these
 

00:03:20.360 --> 00:03:22.720 align:start position:0%
in this example I'd like to add these
three<00:03:20.810><c> values</c><00:03:21.019><c> and</c><00:03:21.560><c> find</c><00:03:21.860><c> out</c><00:03:22.099><c> how</c><00:03:22.310><c> much</c><00:03:22.489><c> the</c>

00:03:22.720 --> 00:03:22.730 align:start position:0%
three values and find out how much the
 

00:03:22.730 --> 00:03:25.330 align:start position:0%
three values and find out how much the
sales<00:03:22.970><c> tax</c><00:03:23.360><c> will</c><00:03:23.599><c> be</c><00:03:23.629><c> I'll</c><00:03:24.050><c> start</c><00:03:24.950><c> by</c><00:03:25.099><c> typing</c>

00:03:25.330 --> 00:03:25.340 align:start position:0%
sales tax will be I'll start by typing
 

00:03:25.340 --> 00:03:27.130 align:start position:0%
sales tax will be I'll start by typing
the<00:03:25.580><c> equal</c><00:03:25.730><c> sign</c><00:03:26.209><c> which</c><00:03:26.569><c> is</c><00:03:26.599><c> how</c><00:03:26.900><c> you</c><00:03:26.959><c> always</c>

00:03:27.130 --> 00:03:27.140 align:start position:0%
the equal sign which is how you always
 

00:03:27.140 --> 00:03:30.729 align:start position:0%
the equal sign which is how you always
start<00:03:27.830><c> a</c><00:03:27.950><c> formula</c><00:03:28.430><c> then</c><00:03:29.030><c> I'll</c><00:03:29.360><c> calculate</c><00:03:29.690><c> D</c><00:03:30.349><c> 3</c>

00:03:30.729 --> 00:03:30.739 align:start position:0%
start a formula then I'll calculate D 3
 

00:03:30.739 --> 00:03:36.850 align:start position:0%
start a formula then I'll calculate D 3
+<00:03:31.549><c> d</c><00:03:31.910><c> 4</c><00:03:31.940><c> +</c><00:03:32.599><c> D</c><00:03:33.410><c> 5</c><00:03:34.090><c> next</c><00:03:35.090><c> I'll</c><00:03:35.480><c> multiply</c><00:03:36.110><c> by</c><00:03:36.410><c> point</c>

00:03:36.850 --> 00:03:36.860 align:start position:0%
+ d 4 + D 5 next I'll multiply by point
 

00:03:36.860 --> 00:03:40.180 align:start position:0%
+ d 4 + D 5 next I'll multiply by point
zero<00:03:37.069><c> five</c><00:03:37.910><c> five</c><00:03:38.330><c> which</c><00:03:39.019><c> is</c><00:03:39.049><c> the</c><00:03:39.260><c> tax</c><00:03:39.650><c> rate</c><00:03:39.799><c> at</c>

00:03:40.180 --> 00:03:40.190 align:start position:0%
zero five five which is the tax rate at
 

00:03:40.190 --> 00:03:43.630 align:start position:0%
zero five five which is the tax rate at
five<00:03:40.640><c> point</c><00:03:41.030><c> five</c><00:03:41.269><c> percent</c><00:03:42.010><c> now</c><00:03:43.010><c> is</c><00:03:43.370><c> this</c>

00:03:43.630 --> 00:03:43.640 align:start position:0%
five point five percent now is this
 

00:03:43.640 --> 00:03:45.280 align:start position:0%
five point five percent now is this
formula<00:03:44.209><c> going</c><00:03:44.390><c> to</c><00:03:44.599><c> give</c><00:03:44.750><c> us</c><00:03:44.870><c> the</c><00:03:45.049><c> correct</c>

00:03:45.280 --> 00:03:45.290 align:start position:0%
formula going to give us the correct
 

00:03:45.290 --> 00:03:48.850 align:start position:0%
formula going to give us the correct
answer<00:03:45.579><c> no</c><00:03:46.579><c> it's</c><00:03:46.910><c> not</c><00:03:47.290><c> multiplication</c><00:03:48.290><c> comes</c>

00:03:48.850 --> 00:03:48.860 align:start position:0%
answer no it's not multiplication comes
 

00:03:48.860 --> 00:03:50.500 align:start position:0%
answer no it's not multiplication comes
before<00:03:49.040><c> addition</c><00:03:49.430><c> in</c><00:03:50.030><c> the</c><00:03:50.180><c> order</c><00:03:50.480><c> of</c>

00:03:50.500 --> 00:03:50.510 align:start position:0%
before addition in the order of
 

00:03:50.510 --> 00:03:53.140 align:start position:0%
before addition in the order of
operations<00:03:50.890><c> so</c><00:03:51.890><c> the</c><00:03:52.069><c> spreadsheet</c><00:03:52.640><c> is</c><00:03:52.849><c> going</c>

00:03:53.140 --> 00:03:53.150 align:start position:0%
operations so the spreadsheet is going
 

00:03:53.150 --> 00:03:56.650 align:start position:0%
operations so the spreadsheet is going
to<00:03:53.269><c> multiply</c><00:03:53.780><c> D</c><00:03:54.470><c> five</c><00:03:54.829><c> by</c><00:03:55.370><c> point</c><00:03:55.819><c> zero</c><00:03:55.970><c> five</c>

00:03:56.650 --> 00:03:56.660 align:start position:0%
to multiply D five by point zero five
 

00:03:56.660 --> 00:04:01.150 align:start position:0%
to multiply D five by point zero five
five<00:03:57.049><c> first</c><00:03:57.590><c> then</c><00:03:58.519><c> it'll</c><00:03:59.150><c> add</c><00:03:59.420><c> D</c><00:04:00.019><c> 3</c><00:04:00.440><c> and</c><00:04:00.590><c> d</c><00:04:00.680><c> 4</c>

00:04:01.150 --> 00:04:01.160 align:start position:0%
five first then it'll add D 3 and d 4
 

00:04:01.160 --> 00:04:04.390 align:start position:0%
five first then it'll add D 3 and d 4
which<00:04:01.790><c> isn't</c><00:04:02.480><c> what</c><00:04:02.660><c> we</c><00:04:02.810><c> want</c><00:04:03.049><c> we</c><00:04:03.950><c> want</c><00:04:04.190><c> these</c>

00:04:04.390 --> 00:04:04.400 align:start position:0%
which isn't what we want we want these
 

00:04:04.400 --> 00:04:07.690 align:start position:0%
which isn't what we want we want these
three<00:04:04.819><c> values</c><00:04:05.030><c> to</c><00:04:05.569><c> be</c><00:04:05.599><c> added</c><00:04:06.079><c> first</c><00:04:06.410><c> so</c><00:04:07.280><c> to</c><00:04:07.340><c> do</c>

00:04:07.690 --> 00:04:07.700 align:start position:0%
three values to be added first so to do
 

00:04:07.700 --> 00:04:09.430 align:start position:0%
three values to be added first so to do
that<00:04:07.970><c> we</c><00:04:08.299><c> just</c><00:04:08.329><c> need</c><00:04:08.629><c> to</c><00:04:08.780><c> put</c><00:04:09.079><c> them</c><00:04:09.230><c> in</c>

00:04:09.430 --> 00:04:09.440 align:start position:0%
that we just need to put them in
 

00:04:09.440 --> 00:04:11.680 align:start position:0%
that we just need to put them in
parentheses

00:04:11.680 --> 00:04:11.690 align:start position:0%
parentheses
 

00:04:11.690 --> 00:04:13.930 align:start position:0%
parentheses
parentheses<00:04:12.590><c> are</c><00:04:12.830><c> often</c><00:04:13.310><c> the</c><00:04:13.430><c> best</c><00:04:13.670><c> way</c><00:04:13.910><c> of</c>

00:04:13.930 --> 00:04:13.940 align:start position:0%
parentheses are often the best way of
 

00:04:13.940 --> 00:04:15.820 align:start position:0%
parentheses are often the best way of
controlling<00:04:14.510><c> which</c><00:04:14.870><c> parts</c><00:04:15.260><c> of</c><00:04:15.350><c> the</c><00:04:15.410><c> formula</c>

00:04:15.820 --> 00:04:15.830 align:start position:0%
controlling which parts of the formula
 

00:04:15.830 --> 00:04:18.460 align:start position:0%
controlling which parts of the formula
are<00:04:16.190><c> calculated</c><00:04:16.970><c> first</c><00:04:17.209><c> and</c><00:04:17.600><c> when</c><00:04:18.290><c> this</c>

00:04:18.460 --> 00:04:18.470 align:start position:0%
are calculated first and when this
 

00:04:18.470 --> 00:04:21.190 align:start position:0%
are calculated first and when this
formula<00:04:18.980><c> is</c><00:04:19.160><c> calculated</c><00:04:19.850><c> we</c><00:04:20.660><c> can</c><00:04:20.840><c> see</c><00:04:21.049><c> that</c>

00:04:21.190 --> 00:04:21.200 align:start position:0%
formula is calculated we can see that
 

00:04:21.200 --> 00:04:25.870 align:start position:0%
formula is calculated we can see that
the<00:04:21.350><c> answer</c><00:04:21.739><c> is</c><00:04:22.990><c> $15.08</c><00:04:24.130><c> so</c><00:04:25.130><c> whenever</c><00:04:25.490><c> you're</c>

00:04:25.870 --> 00:04:25.880 align:start position:0%
the answer is $15.08 so whenever you're
 

00:04:25.880 --> 00:04:28.240 align:start position:0%
the answer is $15.08 so whenever you're
doing<00:04:26.090><c> a</c><00:04:26.330><c> complex</c><00:04:26.360><c> formula</c><00:04:27.140><c> just</c><00:04:27.500><c> remember</c><00:04:28.130><c> to</c>

00:04:28.240 --> 00:04:28.250 align:start position:0%
doing a complex formula just remember to
 

00:04:28.250 --> 00:04:30.400 align:start position:0%
doing a complex formula just remember to
follow<00:04:28.400><c> the</c><00:04:28.700><c> order</c><00:04:29.000><c> of</c><00:04:29.030><c> operations</c><00:04:29.810><c> then</c>

00:04:30.400 --> 00:04:30.410 align:start position:0%
follow the order of operations then
 

00:04:30.410 --> 00:04:36.690 align:start position:0%
follow the order of operations then
you'll<00:04:30.590><c> get</c><00:04:30.740><c> the</c><00:04:30.890><c> correct</c><00:04:31.220><c> answer</c><00:04:31.400><c> every</c><00:04:32.150><c> time</c>

00:04:36.690 --> 00:04:36.700 align:start position:0%
 
 

00:04:36.700 --> 00:04:40.420 align:start position:0%
 
GCF<00:04:37.700><c> global</c><00:04:38.380><c> creating</c><00:04:39.380><c> opportunities</c><00:04:40.040><c> for</c><00:04:40.370><c> a</c>

00:04:40.420 --> 00:04:40.430 align:start position:0%
GCF global creating opportunities for a
 

00:04:40.430 --> 00:04:42.940 align:start position:0%
GCF global creating opportunities for a
better<00:04:40.490><c> life</c>