WEBVTT
Kind: captions
Language: en

00:00:10.250 --> 00:00:12.410 align:start position:0%
 
we've<00:00:11.250><c> already</c><00:00:11.430><c> talked</c><00:00:11.790><c> about</c><00:00:11.910><c> how</c><00:00:12.059><c> to</c><00:00:12.270><c> create</c>

00:00:12.410 --> 00:00:12.420 align:start position:0%
we've already talked about how to create
 

00:00:12.420 --> 00:00:14.900 align:start position:0%
we've already talked about how to create
simple<00:00:13.020><c> formulas</c><00:00:13.650><c> that</c><00:00:13.680><c> only</c><00:00:14.010><c> have</c><00:00:14.280><c> one</c><00:00:14.639><c> type</c>

00:00:14.900 --> 00:00:14.910 align:start position:0%
simple formulas that only have one type
 

00:00:14.910 --> 00:00:17.179 align:start position:0%
simple formulas that only have one type
of<00:00:14.940><c> operation</c><00:00:15.470><c> but</c><00:00:16.470><c> sometimes</c><00:00:16.830><c> you'll</c><00:00:17.040><c> have</c>

00:00:17.179 --> 00:00:17.189 align:start position:0%
of operation but sometimes you'll have
 

00:00:17.189 --> 00:00:19.280 align:start position:0%
of operation but sometimes you'll have
to<00:00:17.340><c> create</c><00:00:17.610><c> a</c><00:00:17.730><c> more</c><00:00:18.119><c> complex</c><00:00:18.420><c> formula</c><00:00:19.080><c> that</c>

00:00:19.280 --> 00:00:19.290 align:start position:0%
to create a more complex formula that
 

00:00:19.290 --> 00:00:21.710 align:start position:0%
to create a more complex formula that
has<00:00:19.410><c> more</c><00:00:19.740><c> than</c><00:00:19.800><c> one</c><00:00:20.189><c> type</c><00:00:20.460><c> of</c><00:00:20.490><c> operation</c><00:00:21.180><c> for</c>

00:00:21.710 --> 00:00:21.720 align:start position:0%
has more than one type of operation for
 

00:00:21.720 --> 00:00:25.220 align:start position:0%
has more than one type of operation for
example<00:00:21.890><c> addition</c><00:00:22.890><c> and</c><00:00:23.160><c> multiplication</c><00:00:24.230><c> to</c>

00:00:25.220 --> 00:00:25.230 align:start position:0%
example addition and multiplication to
 

00:00:25.230 --> 00:00:27.139 align:start position:0%
example addition and multiplication to
do<00:00:25.380><c> this</c><00:00:25.590><c> you'll</c><00:00:25.980><c> need</c><00:00:26.070><c> to</c><00:00:26.220><c> understand</c><00:00:26.849><c> how</c>

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

00:00:27.149 --> 00:00:30.440 align:start position:0%
do this you'll need to understand how
Excel<00:00:27.689><c> is</c><00:00:27.899><c> calculating</c><00:00:28.619><c> the</c><00:00:28.739><c> answer</c><00:00:29.450><c> Excel</c>

00:00:30.440 --> 00:00:30.450 align:start position:0%
Excel is calculating the answer Excel
 

00:00:30.450 --> 00:00:32.540 align:start position:0%
Excel is calculating the answer Excel
uses<00:00:30.840><c> a</c><00:00:30.869><c> set</c><00:00:31.140><c> of</c><00:00:31.169><c> rules</c><00:00:31.470><c> called</c><00:00:31.619><c> the</c><00:00:32.040><c> order</c><00:00:32.369><c> of</c>

00:00:32.540 --> 00:00:32.550 align:start position:0%
uses a set of rules called the order of
 

00:00:32.550 --> 00:00:34.490 align:start position:0%
uses a set of rules called the order of
operations<00:00:33.270><c> which</c><00:00:33.780><c> you</c><00:00:33.930><c> might</c><00:00:34.050><c> remember</c><00:00:34.260><c> from</c>

00:00:34.490 --> 00:00:34.500 align:start position:0%
operations which you might remember from
 

00:00:34.500 --> 00:00:37.280 align:start position:0%
operations which you might remember from
math<00:00:34.800><c> class</c><00:00:35.300><c> the</c><00:00:36.300><c> order</c><00:00:36.570><c> of</c><00:00:36.690><c> operations</c>

00:00:37.280 --> 00:00:37.290 align:start position:0%
math class the order of operations
 

00:00:37.290 --> 00:00:39.260 align:start position:0%
math class the order of operations
determines<00:00:37.860><c> which</c><00:00:38.100><c> parts</c><00:00:38.489><c> of</c><00:00:38.610><c> the</c><00:00:38.670><c> formula</c><00:00:38.969><c> to</c>

00:00:39.260 --> 00:00:39.270 align:start position:0%
determines which parts of the formula to
 

00:00:39.270 --> 00:00:42.170 align:start position:0%
determines which parts of the formula to
calculate<00:00:39.300><c> first</c><00:00:40.460><c> the</c><00:00:41.460><c> very</c><00:00:41.640><c> first</c><00:00:41.820><c> thing</c>

00:00:42.170 --> 00:00:42.180 align:start position:0%
calculate first the very first thing
 

00:00:42.180 --> 00:00:43.760 align:start position:0%
calculate first the very first thing
that<00:00:42.210><c> you</c><00:00:42.360><c> calculate</c><00:00:42.900><c> is</c><00:00:43.110><c> items</c><00:00:43.530><c> and</c>

00:00:43.760 --> 00:00:43.770 align:start position:0%
that you calculate is items and
 

00:00:43.770 --> 00:00:46.700 align:start position:0%
that you calculate is items and
parentheses<00:00:44.870><c> then</c><00:00:45.870><c> if</c><00:00:46.140><c> you</c><00:00:46.380><c> have</c><00:00:46.560><c> any</c>

00:00:46.700 --> 00:00:46.710 align:start position:0%
parentheses then if you have any
 

00:00:46.710 --> 00:00:49.750 align:start position:0%
parentheses then if you have any
exponents<00:00:47.130><c> you'll</c><00:00:47.700><c> calculate</c><00:00:47.910><c> those</c>

00:00:49.750 --> 00:00:49.760 align:start position:0%
exponents you'll calculate those
 

00:00:49.760 --> 00:00:52.440 align:start position:0%
exponents you'll calculate those
next<00:00:50.540><c> is</c><00:00:50.660><c> multiplication</c><00:00:51.320><c> and</c><00:00:51.680><c> division</c><00:00:52.130><c> and</c>

00:00:52.440 --> 00:00:52.450 align:start position:0%
next is multiplication and division and
 

00:00:52.450 --> 00:00:56.569 align:start position:0%
next is multiplication and division and
lastly<00:00:53.450><c> addition</c><00:00:54.440><c> and</c><00:00:54.620><c> subtraction</c>

00:00:56.569 --> 00:00:56.579 align:start position:0%
lastly addition and subtraction
 

00:00:56.579 --> 00:00:58.760 align:start position:0%
lastly addition and subtraction
Excel<00:00:57.480><c> knows</c><00:00:57.809><c> to</c><00:00:58.079><c> use</c><00:00:58.110><c> the</c><00:00:58.469><c> order</c><00:00:58.739><c> of</c>

00:00:58.760 --> 00:00:58.770 align:start position:0%
Excel knows to use the order of
 

00:00:58.770 --> 00:01:00.590 align:start position:0%
Excel knows to use the order of
operations<00:00:58.950><c> whenever</c><00:00:59.700><c> it</c><00:01:00.000><c> calculates</c><00:01:00.480><c> a</c>

00:01:00.590 --> 00:01:00.600 align:start position:0%
operations whenever it calculates a
 

00:01:00.600 --> 00:01:02.600 align:start position:0%
operations whenever it calculates a
complex<00:01:00.870><c> formula</c><00:01:01.470><c> and</c><00:01:01.649><c> it's</c><00:01:02.100><c> important</c><00:01:02.489><c> that</c>

00:01:02.600 --> 00:01:02.610 align:start position:0%
complex formula and it's important that
 

00:01:02.610 --> 00:01:04.070 align:start position:0%
complex formula and it's important that
you<00:01:02.760><c> remember</c><00:01:03.059><c> it</c><00:01:03.329><c> so</c><00:01:03.480><c> that</c><00:01:03.600><c> you</c><00:01:03.690><c> can</c><00:01:03.840><c> create</c>

00:01:04.070 --> 00:01:04.080 align:start position:0%
you remember it so that you can create
 

00:01:04.080 --> 00:01:05.810 align:start position:0%
you remember it so that you can create
formulas<00:01:04.739><c> that</c><00:01:04.769><c> will</c><00:01:05.070><c> give</c><00:01:05.250><c> you</c><00:01:05.369><c> the</c><00:01:05.489><c> correct</c>

00:01:05.810 --> 00:01:05.820 align:start position:0%
formulas that will give you the correct
 

00:01:05.820 --> 00:01:06.440 align:start position:0%
formulas that will give you the correct
answer

00:01:06.440 --> 00:01:06.450 align:start position:0%
answer
 

00:01:06.450 --> 00:01:08.930 align:start position:0%
answer
to<00:01:07.440><c> remember</c><00:01:07.710><c> the</c><00:01:07.979><c> order</c><00:01:08.190><c> you</c><00:01:08.460><c> can</c><00:01:08.640><c> just</c><00:01:08.790><c> use</c>

00:01:08.930 --> 00:01:08.940 align:start position:0%
to remember the order you can just use
 

00:01:08.940 --> 00:01:12.020 align:start position:0%
to remember the order you can just use
the<00:01:09.090><c> acronym</c><00:01:09.320><c> PEMDAS</c><00:01:10.320><c> or</c><00:01:10.670><c> to</c><00:01:11.670><c> make</c><00:01:11.820><c> it</c><00:01:11.850><c> even</c>

00:01:12.020 --> 00:01:12.030 align:start position:0%
the acronym PEMDAS or to make it even
 

00:01:12.030 --> 00:01:14.600 align:start position:0%
the acronym PEMDAS or to make it even
easier<00:01:12.210><c> just</c><00:01:12.990><c> remember</c><00:01:13.409><c> the</c><00:01:13.530><c> phrase</c><00:01:13.740><c> please</c>

00:01:14.600 --> 00:01:14.610 align:start position:0%
easier just remember the phrase please
 

00:01:14.610 --> 00:01:17.820 align:start position:0%
easier just remember the phrase please
excuse<00:01:15.420><c> my</c><00:01:15.690><c> dear</c><00:01:15.750><c> Aunt</c><00:01:16.140><c> Sally</c>

00:01:17.820 --> 00:01:17.830 align:start position:0%
excuse my dear Aunt Sally
 

00:01:17.830 --> 00:01:20.040 align:start position:0%
excuse my dear Aunt Sally
let's<00:01:18.490><c> go</c><00:01:18.670><c> over</c><00:01:18.820><c> each</c><00:01:19.060><c> of</c><00:01:19.120><c> these</c><00:01:19.390><c> and</c><00:01:19.690><c> a</c><00:01:19.810><c> little</c>

00:01:20.040 --> 00:01:20.050 align:start position:0%
let's go over each of these and a little
 

00:01:20.050 --> 00:01:21.860 align:start position:0%
let's go over each of these and a little
more<00:01:20.170><c> detail</c>

00:01:21.860 --> 00:01:21.870 align:start position:0%
more detail
 

00:01:21.870 --> 00:01:24.650 align:start position:0%
more detail
in<00:01:21.930><c> this</c><00:01:22.680><c> formula</c><00:01:23.010><c> five</c><00:01:23.610><c> plus</c><00:01:23.910><c> two</c><00:01:24.210><c> is</c><00:01:24.450><c> in</c>

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

00:01:24.660 --> 00:01:26.870 align:start position:0%
in this formula five plus two is in
parentheses<00:01:25.260><c> so</c><00:01:26.010><c> we'll</c><00:01:26.160><c> calculate</c><00:01:26.400><c> that</c>

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

00:01:26.880 --> 00:01:29.990 align:start position:0%
parentheses so we'll calculate that
first<00:01:27.240><c> to</c><00:01:27.690><c> get</c><00:01:27.840><c> seven</c><00:01:28.410><c> and</c><00:01:28.590><c> then</c><00:01:29.580><c> we</c><00:01:29.730><c> can</c><00:01:29.880><c> just</c>

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

00:01:30.000 --> 00:01:36.730 align:start position:0%
first to get seven and then we can just
multiply<00:01:30.060><c> three</c><00:01:31.020><c> times</c><00:01:31.050><c> seven</c><00:01:31.650><c> to</c><00:01:32.160><c> get</c><00:01:32.340><c> 21</c>

00:01:36.730 --> 00:01:36.740 align:start position:0%
 
 

00:01:36.740 --> 00:01:40.780 align:start position:0%
 
this<00:01:37.400><c> formula</c><00:01:38.000><c> contains</c><00:01:38.180><c> an</c><00:01:38.720><c> exponent</c><00:01:39.110><c> 3</c><00:01:39.890><c> ^</c><00:01:40.130><c> 2</c>

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

00:01:40.790 --> 00:01:43.510 align:start position:0%
this formula contains an exponent 3 ^ 2
and<00:01:41.090><c> we'll</c><00:01:42.049><c> need</c><00:01:42.140><c> to</c><00:01:42.260><c> calculate</c><00:01:42.470><c> that</c><00:01:43.010><c> first</c>

00:01:43.510 --> 00:01:43.520 align:start position:0%
and we'll need to calculate that first
 

00:01:43.520 --> 00:01:49.140 align:start position:0%
and we'll need to calculate that first
before<00:01:44.030><c> doing</c><00:01:44.570><c> the</c><00:01:44.750><c> addition</c>

00:01:49.140 --> 00:01:49.150 align:start position:0%
 
 

00:01:49.150 --> 00:01:50.940 align:start position:0%
 
if<00:01:49.210><c> you</c><00:01:49.900><c> have</c><00:01:50.050><c> multiplication</c><00:01:50.770><c> or</c><00:01:50.920><c> division</c>

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

00:01:50.950 --> 00:01:54.420 align:start position:0%
if you have multiplication or division
that<00:01:51.790><c> will</c><00:01:51.970><c> come</c><00:01:52.180><c> next</c><00:01:52.770><c> here</c><00:01:53.770><c> we</c><00:01:53.890><c> multiply</c><00:01:54.370><c> 2</c>

00:01:54.420 --> 00:01:54.430 align:start position:0%
that will come next here we multiply 2
 

00:01:54.430 --> 00:02:01.560 align:start position:0%
that will come next here we multiply 2
times<00:01:54.640><c> 4</c><00:01:55.240><c> to</c><00:01:55.510><c> get</c><00:01:55.630><c> 8</c><00:01:55.870><c> and</c><00:01:56.220><c> 9</c><00:01:57.220><c> minus</c><00:01:57.430><c> 8</c><00:01:57.790><c> equals</c><00:01:58.510><c> 1</c>

00:02:01.560 --> 00:02:01.570 align:start position:0%
 
 

00:02:01.570 --> 00:02:03.690 align:start position:0%
 
now<00:02:02.290><c> multiplication</c><00:02:03.070><c> and</c><00:02:03.190><c> division</c><00:02:03.550><c> are</c>

00:02:03.690 --> 00:02:03.700 align:start position:0%
now multiplication and division are
 

00:02:03.700 --> 00:02:06.240 align:start position:0%
now multiplication and division are
considered<00:02:04.150><c> to</c><00:02:04.240><c> be</c><00:02:04.360><c> at</c><00:02:04.540><c> the</c><00:02:04.570><c> same</c><00:02:04.990><c> level</c><00:02:05.350><c> and</c>

00:02:06.240 --> 00:02:06.250 align:start position:0%
considered to be at the same level and
 

00:02:06.250 --> 00:02:07.620 align:start position:0%
considered to be at the same level and
that<00:02:06.400><c> means</c><00:02:06.610><c> if</c><00:02:06.730><c> you</c><00:02:06.850><c> have</c><00:02:06.880><c> both</c><00:02:07.270><c> of</c><00:02:07.300><c> them</c><00:02:07.570><c> in</c>

00:02:07.620 --> 00:02:07.630 align:start position:0%
that means if you have both of them in
 

00:02:07.630 --> 00:02:09.690 align:start position:0%
that means if you have both of them in
your<00:02:07.810><c> formula</c><00:02:08.170><c> they're</c><00:02:08.800><c> calculated</c><00:02:09.520><c> from</c>

00:02:09.690 --> 00:02:09.700 align:start position:0%
your formula they're calculated from
 

00:02:09.700 --> 00:02:12.750 align:start position:0%
your formula they're calculated from
left<00:02:10.030><c> to</c><00:02:10.179><c> right</c><00:02:10.540><c> in</c><00:02:10.890><c> this</c><00:02:11.890><c> example</c><00:02:12.310><c> we'll</c><00:02:12.610><c> do</c>

00:02:12.750 --> 00:02:12.760 align:start position:0%
left to right in this example we'll do
 

00:02:12.760 --> 00:02:15.210 align:start position:0%
left to right in this example we'll do
the<00:02:12.910><c> division</c><00:02:13.150><c> first</c><00:02:13.360><c> and</c><00:02:13.960><c> then</c><00:02:14.920><c> the</c>

00:02:15.210 --> 00:02:15.220 align:start position:0%
the division first and then the
 

00:02:15.220 --> 00:02:17.480 align:start position:0%
the division first and then the
multiplication

00:02:17.480 --> 00:02:17.490 align:start position:0%
multiplication
 

00:02:17.490 --> 00:02:19.130 align:start position:0%
multiplication
if<00:02:17.550><c> we</c><00:02:18.030><c> wanted</c><00:02:18.270><c> the</c><00:02:18.330><c> multiplication</c><00:02:18.360><c> to</c>

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

00:02:19.140 --> 00:02:20.720 align:start position:0%
if we wanted the multiplication to
happen<00:02:19.410><c> first</c><00:02:19.650><c> we</c><00:02:20.040><c> could</c><00:02:20.190><c> just</c><00:02:20.310><c> put</c><00:02:20.490><c> it</c><00:02:20.610><c> in</c>

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

00:02:20.730 --> 00:02:22.760 align:start position:0%
happen first we could just put it in
parentheses<00:02:21.360><c> or</c><00:02:21.720><c> we</c><00:02:22.140><c> could</c><00:02:22.290><c> rearrange</c><00:02:22.530><c> the</c>

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

00:02:22.770 --> 00:02:24.800 align:start position:0%
parentheses or we could rearrange the
formula<00:02:23.340><c> so</c><00:02:23.520><c> the</c><00:02:23.610><c> multiplication</c><00:02:24.300><c> was</c><00:02:24.600><c> on</c><00:02:24.720><c> the</c>

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

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

00:02:26.820 --> 00:02:26.830 align:start position:0%
left
 

00:02:26.830 --> 00:02:29.580 align:start position:0%
left
finally<00:02:27.640><c> we</c><00:02:27.880><c> have</c><00:02:28.090><c> addition</c><00:02:28.750><c> and</c><00:02:28.930><c> subtraction</c>

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

00:02:29.590 --> 00:02:32.460 align:start position:0%
finally we have addition and subtraction
just<00:02:30.120><c> like</c><00:02:31.120><c> multiplication</c><00:02:31.510><c> and</c><00:02:31.990><c> division</c>

00:02:32.460 --> 00:02:32.470 align:start position:0%
just like multiplication and division
 

00:02:32.470 --> 00:02:34.830 align:start position:0%
just like multiplication and division
these<00:02:32.620><c> are</c><00:02:33.220><c> on</c><00:02:33.340><c> the</c><00:02:33.460><c> same</c><00:02:33.700><c> level</c><00:02:34.000><c> so</c><00:02:34.720><c> we</c>

00:02:34.830 --> 00:02:34.840 align:start position:0%
these are on the same level so we
 

00:02:34.840 --> 00:02:40.420 align:start position:0%
these are on the same level so we
calculate<00:02:35.320><c> them</c><00:02:35.530><c> from</c><00:02:35.770><c> left</c><00:02:35.980><c> to</c><00:02:36.160><c> right</c>

00:02:40.420 --> 00:02:40.430 align:start position:0%
 
 

00:02:40.430 --> 00:02:43.199 align:start position:0%
 
okay<00:02:40.939><c> now</c><00:02:41.209><c> let's</c><00:02:41.480><c> put</c><00:02:41.720><c> them</c><00:02:41.840><c> all</c><00:02:42.049><c> together</c>

00:02:43.199 --> 00:02:43.209 align:start position:0%
okay now let's put them all together
 

00:02:43.209 --> 00:02:45.990 align:start position:0%
okay now let's put them all together
this<00:02:44.209><c> formula</c><00:02:44.720><c> may</c><00:02:44.989><c> look</c><00:02:45.349><c> really</c><00:02:45.620><c> complicated</c>

00:02:45.990 --> 00:02:46.000 align:start position:0%
this formula may look really complicated
 

00:02:46.000 --> 00:02:48.429 align:start position:0%
this formula may look really complicated
but<00:02:47.000><c> we're</c><00:02:47.209><c> just</c><00:02:47.239><c> going</c><00:02:47.569><c> to</c><00:02:47.689><c> go</c><00:02:47.810><c> step</c><00:02:48.230><c> by</c><00:02:48.260><c> step</c>

00:02:48.429 --> 00:02:48.439 align:start position:0%
but we're just going to go step by step
 

00:02:48.439 --> 00:02:50.559 align:start position:0%
but we're just going to go step by step
through<00:02:49.040><c> the</c><00:02:49.129><c> order</c><00:02:49.549><c> of</c><00:02:49.700><c> operations</c><00:02:50.360><c> and</c>

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

00:02:50.569 --> 00:02:53.009 align:start position:0%
through the order of operations and
you'll<00:02:51.290><c> see</c><00:02:51.470><c> it's</c><00:02:51.620><c> actually</c><00:02:51.769><c> not</c><00:02:52.099><c> that</c><00:02:52.159><c> bad</c>

00:02:53.009 --> 00:02:53.019 align:start position:0%
you'll see it's actually not that bad
 

00:02:53.019 --> 00:02:56.619 align:start position:0%
you'll see it's actually not that bad
we'll<00:02:54.019><c> start</c><00:02:54.379><c> with</c><00:02:54.620><c> the</c><00:02:54.739><c> parentheses</c><00:02:55.629><c> we'll</c>

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

00:02:56.629 --> 00:02:58.929 align:start position:0%
we'll start with the parentheses we'll
calculate<00:02:56.840><c> each</c><00:02:57.349><c> of</c><00:02:57.409><c> these</c><00:02:57.739><c> to</c><00:02:58.069><c> get</c><00:02:58.280><c> two</c><00:02:58.640><c> and</c>

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

00:02:58.939 --> 00:03:01.330 align:start position:0%
calculate each of these to get two and
three<00:02:59.420><c> and</c><00:02:59.599><c> you</c><00:03:00.530><c> can</c><00:03:00.650><c> see</c><00:03:00.829><c> that</c><00:03:00.950><c> the</c><00:03:01.069><c> formula</c>

00:03:01.330 --> 00:03:01.340 align:start position:0%
three and you can see that the formula
 

00:03:01.340 --> 00:03:02.979 align:start position:0%
three and you can see that the formula
is<00:03:01.549><c> already</c><00:03:01.939><c> starting</c><00:03:02.329><c> to</c><00:03:02.359><c> look</c><00:03:02.540><c> a</c><00:03:02.659><c> little</c><00:03:02.780><c> bit</c>

00:03:02.979 --> 00:03:02.989 align:start position:0%
is already starting to look a little bit
 

00:03:02.989 --> 00:03:06.339 align:start position:0%
is already starting to look a little bit
simpler<00:03:04.329><c> next</c><00:03:05.329><c> we'll</c><00:03:05.599><c> look</c><00:03:05.720><c> to</c><00:03:05.870><c> see</c><00:03:06.049><c> if</c><00:03:06.140><c> there</c>

00:03:06.339 --> 00:03:06.349 align:start position:0%
simpler next we'll look to see if there
 

00:03:06.349 --> 00:03:08.110 align:start position:0%
simpler next we'll look to see if there
are<00:03:06.379><c> any</c><00:03:06.500><c> exponents</c><00:03:06.859><c> in</c><00:03:07.370><c> this</c><00:03:07.489><c> formula</c><00:03:07.909><c> and</c>

00:03:08.110 --> 00:03:08.120 align:start position:0%
are any exponents in this formula and
 

00:03:08.120 --> 00:03:10.869 align:start position:0%
are any exponents in this formula and
there<00:03:08.689><c> is</c><00:03:08.840><c> one</c><00:03:09.049><c> two</c><00:03:09.680><c> to</c><00:03:09.950><c> the</c><00:03:10.040><c> second</c><00:03:10.400><c> power</c><00:03:10.430><c> and</c>

00:03:10.869 --> 00:03:10.879 align:start position:0%
there is one two to the second power and
 

00:03:10.879 --> 00:03:14.790 align:start position:0%
there is one two to the second power and
when<00:03:11.750><c> we</c><00:03:11.870><c> calculate</c><00:03:12.079><c> it</c><00:03:12.500><c> it</c><00:03:12.650><c> becomes</c><00:03:13.069><c> four</c>

00:03:14.790 --> 00:03:14.800 align:start position:0%
when we calculate it it becomes four
 

00:03:14.800 --> 00:03:16.980 align:start position:0%
when we calculate it it becomes four
next<00:03:15.700><c> we'll</c><00:03:15.880><c> do</c><00:03:16.000><c> the</c><00:03:16.030><c> multiplication</c><00:03:16.120><c> and</c>

00:03:16.980 --> 00:03:16.990 align:start position:0%
next we'll do the multiplication and
 

00:03:16.990 --> 00:03:22.340 align:start position:0%
next we'll do the multiplication and
division<00:03:17.530><c> going</c><00:03:17.980><c> from</c><00:03:18.190><c> left</c><00:03:18.400><c> to</c><00:03:18.550><c> right</c>

00:03:22.340 --> 00:03:22.350 align:start position:0%
 
 

00:03:22.350 --> 00:03:24.860 align:start position:0%
 
and<00:03:22.440><c> now</c><00:03:23.160><c> all</c><00:03:23.340><c> this</c><00:03:23.520><c> left</c><00:03:23.820><c> is</c><00:03:24.060><c> addition</c><00:03:24.720><c> and</c>

00:03:24.860 --> 00:03:24.870 align:start position:0%
and now all this left is addition and
 

00:03:24.870 --> 00:03:26.870 align:start position:0%
and now all this left is addition and
that<00:03:24.960><c> gives</c><00:03:25.680><c> us</c><00:03:25.800><c> our</c><00:03:25.950><c> answer</c><00:03:26.010><c> which</c><00:03:26.490><c> is</c><00:03:26.520><c> eight</c>

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

00:03:26.880 --> 00:03:29.510 align:start position:0%
that gives us our answer which is eight
point<00:03:27.240><c> seven</c><00:03:27.720><c> five</c><00:03:27.930><c> and</c><00:03:28.290><c> that's</c><00:03:29.130><c> the</c><00:03:29.280><c> same</c>

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

00:03:29.520 --> 00:03:31.220 align:start position:0%
point seven five and that's the same
answer<00:03:29.730><c> that</c><00:03:29.910><c> Excel</c><00:03:30.420><c> would</c><00:03:30.630><c> give</c><00:03:30.810><c> you</c><00:03:30.930><c> if</c><00:03:31.110><c> you</c>

00:03:31.220 --> 00:03:31.230 align:start position:0%
answer that Excel would give you if you
 

00:03:31.230 --> 00:03:35.780 align:start position:0%
answer that Excel would give you if you
entered<00:03:31.560><c> in</c><00:03:31.650><c> that</c><00:03:31.860><c> formula</c>

00:03:35.780 --> 00:03:35.790 align:start position:0%
 
 

00:03:35.790 --> 00:03:37.729 align:start position:0%
 
it's<00:03:36.360><c> important</c><00:03:36.840><c> to</c><00:03:36.930><c> keep</c><00:03:37.110><c> these</c><00:03:37.260><c> rules</c><00:03:37.500><c> in</c>

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

00:03:37.739 --> 00:03:39.699 align:start position:0%
it's important to keep these rules in
mind<00:03:37.980><c> when</c><00:03:38.280><c> you're</c><00:03:38.400><c> creating</c><00:03:38.579><c> a</c><00:03:39.000><c> formula</c><00:03:39.480><c> in</c>

00:03:39.699 --> 00:03:39.709 align:start position:0%
mind when you're creating a formula in
 

00:03:39.709 --> 00:03:42.920 align:start position:0%
mind when you're creating a formula in
this<00:03:40.709><c> example</c><00:03:41.159><c> I'd</c><00:03:41.489><c> like</c><00:03:41.549><c> to</c><00:03:41.790><c> add</c><00:03:41.909><c> these</c><00:03:42.569><c> three</c>

00:03:42.920 --> 00:03:42.930 align:start position:0%
this example I'd like to add these three
 

00:03:42.930 --> 00:03:45.559 align:start position:0%
this example I'd like to add these three
values<00:03:43.079><c> and</c><00:03:43.609><c> find</c><00:03:44.609><c> out</c><00:03:44.760><c> how</c><00:03:44.939><c> much</c><00:03:45.120><c> the</c><00:03:45.359><c> tax</c>

00:03:45.559 --> 00:03:45.569 align:start position:0%
values and find out how much the tax
 

00:03:45.569 --> 00:03:47.869 align:start position:0%
values and find out how much the tax
will<00:03:45.780><c> be</c><00:03:45.810><c> and</c><00:03:46.170><c> let's</c><00:03:46.920><c> say</c><00:03:47.040><c> the</c><00:03:47.159><c> tax</c><00:03:47.400><c> rate</c><00:03:47.700><c> is</c>

00:03:47.869 --> 00:03:47.879 align:start position:0%
will be and let's say the tax rate is
 

00:03:47.879 --> 00:03:51.260 align:start position:0%
will be and let's say the tax rate is
five<00:03:48.180><c> point</c><00:03:48.540><c> five</c><00:03:48.780><c> percent</c>

00:03:51.260 --> 00:03:51.270 align:start position:0%
 
 

00:03:51.270 --> 00:03:53.720 align:start position:0%
 
I'll<00:03:51.350><c> start</c><00:03:52.350><c> by</c><00:03:52.500><c> typing</c><00:03:52.740><c> the</c><00:03:53.040><c> equals</c><00:03:53.430><c> sign</c>

00:03:53.720 --> 00:03:53.730 align:start position:0%
I'll start by typing the equals sign
 

00:03:53.730 --> 00:03:57.030 align:start position:0%
I'll start by typing the equals sign
which<00:03:54.240><c> is</c><00:03:54.360><c> how</c><00:03:54.480><c> you</c><00:03:54.540><c> always</c><00:03:54.630><c> start</c><00:03:55.260><c> a</c><00:03:55.320><c> formula</c>

00:03:57.030 --> 00:03:57.040 align:start position:0%
which is how you always start a formula
 

00:03:57.040 --> 00:04:02.429 align:start position:0%
which is how you always start a formula
I'll<00:03:57.159><c> add</c><00:03:57.430><c> D</c><00:03:57.969><c> four</c><00:03:58.299><c> plus</c><00:03:59.049><c> d</c><00:03:59.680><c> 5</c><00:04:00.030><c> plus</c><00:04:01.030><c> D</c><00:04:01.719><c> 6</c><00:04:02.170><c> and</c>

00:04:02.429 --> 00:04:02.439 align:start position:0%
I'll add D four plus d 5 plus D 6 and
 

00:04:02.439 --> 00:04:05.309 align:start position:0%
I'll add D four plus d 5 plus D 6 and
then<00:04:03.370><c> I'll</c><00:04:03.489><c> multiply</c><00:04:03.670><c> it</c><00:04:03.969><c> by</c><00:04:04.239><c> point</c><00:04:04.629><c> zero</c><00:04:04.959><c> five</c>

00:04:05.309 --> 00:04:05.319 align:start position:0%
then I'll multiply it by point zero five
 

00:04:05.319 --> 00:04:09.449 align:start position:0%
then I'll multiply it by point zero five
five<00:04:05.739><c> which</c><00:04:06.459><c> is</c><00:04:06.489><c> five</c><00:04:06.700><c> point</c><00:04:07.359><c> five</c><00:04:07.569><c> percent</c>

00:04:09.449 --> 00:04:09.459 align:start position:0%
five which is five point five percent
 

00:04:09.459 --> 00:04:12.089 align:start position:0%
five which is five point five percent
now<00:04:10.209><c> is</c><00:04:10.450><c> this</c><00:04:10.719><c> formula</c><00:04:11.290><c> going</c><00:04:11.620><c> to</c><00:04:11.709><c> give</c><00:04:11.829><c> us</c><00:04:11.950><c> the</c>

00:04:12.089 --> 00:04:12.099 align:start position:0%
now is this formula going to give us the
 

00:04:12.099 --> 00:04:16.099 align:start position:0%
now is this formula going to give us the
correct<00:04:12.340><c> result</c><00:04:13.829><c> no</c><00:04:14.829><c> it's</c><00:04:15.099><c> not</c>

00:04:16.099 --> 00:04:16.109 align:start position:0%
correct result no it's not
 

00:04:16.109 --> 00:04:19.020 align:start position:0%
correct result no it's not
multiplication<00:04:17.109><c> comes</c><00:04:17.320><c> before</c><00:04:17.470><c> addition</c><00:04:18.030><c> so</c>

00:04:19.020 --> 00:04:19.030 align:start position:0%
multiplication comes before addition so
 

00:04:19.030 --> 00:04:22.590 align:start position:0%
multiplication comes before addition so
Excel<00:04:19.570><c> will</c><00:04:19.780><c> first</c><00:04:20.079><c> multiply</c><00:04:20.519><c> d6</c><00:04:21.519><c> times</c><00:04:22.210><c> point</c>

00:04:22.590 --> 00:04:22.600 align:start position:0%
Excel will first multiply d6 times point
 

00:04:22.600 --> 00:04:25.890 align:start position:0%
Excel will first multiply d6 times point
zero<00:04:22.960><c> five</c><00:04:23.259><c> five</c><00:04:23.650><c> and</c><00:04:24.039><c> then</c><00:04:24.910><c> it</c><00:04:25.030><c> will</c><00:04:25.150><c> add</c><00:04:25.300><c> d4</c>

00:04:25.890 --> 00:04:25.900 align:start position:0%
zero five five and then it will add d4
 

00:04:25.900 --> 00:04:28.620 align:start position:0%
zero five five and then it will add d4
and<00:04:26.110><c> d5</c><00:04:26.169><c> and</c><00:04:26.949><c> that's</c><00:04:27.550><c> actually</c><00:04:27.820><c> not</c><00:04:28.180><c> what</c><00:04:28.479><c> we</c>

00:04:28.620 --> 00:04:28.630 align:start position:0%
and d5 and that's actually not what we
 

00:04:28.630 --> 00:04:31.350 align:start position:0%
and d5 and that's actually not what we
want<00:04:29.009><c> we</c><00:04:30.009><c> want</c><00:04:30.039><c> these</c><00:04:30.550><c> three</c><00:04:30.789><c> values</c><00:04:31.000><c> to</c><00:04:31.330><c> be</c>

00:04:31.350 --> 00:04:31.360 align:start position:0%
want we want these three values to be
 

00:04:31.360 --> 00:04:33.779 align:start position:0%
want we want these three values to be
added<00:04:31.810><c> first</c><00:04:32.259><c> and</c><00:04:32.530><c> we</c><00:04:33.070><c> can</c><00:04:33.250><c> do</c><00:04:33.400><c> that</c><00:04:33.550><c> by</c><00:04:33.759><c> just</c>

00:04:33.779 --> 00:04:33.789 align:start position:0%
added first and we can do that by just
 

00:04:33.789 --> 00:04:36.420 align:start position:0%
added first and we can do that by just
putting<00:04:34.330><c> them</c><00:04:34.479><c> in</c><00:04:34.720><c> parentheses</c><00:04:35.440><c> parentheses</c>

00:04:36.420 --> 00:04:36.430 align:start position:0%
putting them in parentheses parentheses
 

00:04:36.430 --> 00:04:38.520 align:start position:0%
putting them in parentheses parentheses
are<00:04:36.970><c> often</c><00:04:37.300><c> the</c><00:04:37.389><c> best</c><00:04:37.570><c> way</c><00:04:37.720><c> of</c><00:04:37.870><c> controlling</c>

00:04:38.520 --> 00:04:38.530 align:start position:0%
are often the best way of controlling
 

00:04:38.530 --> 00:04:40.650 align:start position:0%
are often the best way of controlling
which<00:04:38.860><c> parts</c><00:04:39.220><c> the</c><00:04:39.370><c> formula</c><00:04:39.850><c> are</c><00:04:40.030><c> calculated</c>

00:04:40.650 --> 00:04:40.660 align:start position:0%
which parts the formula are calculated
 

00:04:40.660 --> 00:04:42.650 align:start position:0%
which parts the formula are calculated
first

00:04:42.650 --> 00:04:42.660 align:start position:0%
first
 

00:04:42.660 --> 00:04:45.200 align:start position:0%
first
and<00:04:42.750><c> when</c><00:04:43.680><c> this</c><00:04:43.800><c> formula</c><00:04:44.250><c> is</c><00:04:44.370><c> calculated</c><00:04:44.760><c> the</c>

00:04:45.200 --> 00:04:45.210 align:start position:0%
and when this formula is calculated the
 

00:04:45.210 --> 00:04:47.780 align:start position:0%
and when this formula is calculated the
answer<00:04:45.750><c> is</c><00:04:45.960><c> four</c><00:04:46.470><c> dollars</c><00:04:46.890><c> and</c><00:04:47.130><c> sixty-five</c>

00:04:47.780 --> 00:04:47.790 align:start position:0%
answer is four dollars and sixty-five
 

00:04:47.790 --> 00:04:49.720 align:start position:0%
answer is four dollars and sixty-five
cents

00:04:49.720 --> 00:04:49.730 align:start position:0%
cents
 

00:04:49.730 --> 00:04:51.100 align:start position:0%
cents
so<00:04:50.330><c> whenever</c><00:04:50.480><c> you're</c><00:04:50.750><c> doing</c><00:04:50.870><c> a</c><00:04:51.080><c> complex</c>

00:04:51.100 --> 00:04:51.110 align:start position:0%
so whenever you're doing a complex
 

00:04:51.110 --> 00:04:53.410 align:start position:0%
so whenever you're doing a complex
formula<00:04:52.040><c> you'll</c><00:04:52.550><c> need</c><00:04:52.730><c> to</c><00:04:52.820><c> think</c><00:04:53.060><c> about</c><00:04:53.270><c> the</c>

00:04:53.410 --> 00:04:53.420 align:start position:0%
formula you'll need to think about the
 

00:04:53.420 --> 00:04:55.270 align:start position:0%
formula you'll need to think about the
order<00:04:53.600><c> of</c><00:04:53.780><c> operations</c><00:04:54.380><c> to</c><00:04:54.650><c> make</c><00:04:54.770><c> sure</c><00:04:55.070><c> that</c>

00:04:55.270 --> 00:04:55.280 align:start position:0%
order of operations to make sure that
 

00:04:55.280 --> 00:04:56.800 align:start position:0%
order of operations to make sure that
your<00:04:55.430><c> formulas</c><00:04:55.910><c> give</c><00:04:56.210><c> you</c><00:04:56.330><c> the</c><00:04:56.510><c> correct</c>

00:04:56.800 --> 00:04:56.810 align:start position:0%
your formulas give you the correct
 

00:04:56.810 --> 00:05:01.930 align:start position:0%
your formulas give you the correct
answer<00:04:58.510><c> like</c><00:04:59.510><c> what</c><00:04:59.720><c> you</c><00:04:59.870><c> just</c><00:04:59.900><c> saw</c><00:05:00.760><c> rate</c><00:05:01.760><c> it</c>

00:05:01.930 --> 00:05:01.940 align:start position:0%
answer like what you just saw rate it
 

00:05:01.940 --> 00:05:05.590 align:start position:0%
answer like what you just saw rate it
add<00:05:02.420><c> a</c><00:05:02.480><c> comment</c><00:05:02.810><c> subscribe</c><00:05:03.560><c> to</c><00:05:04.010><c> our</c><00:05:04.100><c> chill</c><00:05:04.600><c> the</c>

00:05:05.590 --> 00:05:05.600 align:start position:0%
add a comment subscribe to our chill the
 

00:05:05.600 --> 00:05:07.299 align:start position:0%
add a comment subscribe to our chill the
freedom<00:05:06.020><c> to</c><00:05:06.050><c> learn</c>

00:05:07.299 --> 00:05:07.309 align:start position:0%
freedom to learn
 

00:05:07.309 --> 00:05:11.700 align:start position:0%
freedom to learn
what<00:05:07.969><c> you</c><00:05:08.149><c> want</c><00:05:08.649><c> when</c><00:05:09.649><c> you</c><00:05:09.679><c> want</c>

00:05:11.700 --> 00:05:11.710 align:start position:0%
what you want when you want
 

00:05:11.710 --> 00:05:16.220 align:start position:0%
what you want when you want
absolutely<00:05:12.710><c> food</c>

00:05:16.220 --> 00:05:16.230 align:start position:0%
 
 

00:05:16.230 --> 00:05:19.860 align:start position:0%
 
GCF<00:05:17.230><c> learn</c><00:05:17.830><c> free.org</c>