Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,940 --> 00:00:06,960
In this video we learn how to use logical formulas in Excel.
2
00:00:08,180 --> 00:00:15,110
We will further analyze the sales data of the game store that we used in mathematical formulas case
3
00:00:15,110 --> 00:00:20,990
study and we'll use this case study to learn how to use logical formulas.
4
00:00:20,990 --> 00:00:28,580
If you remember we had calculated quarterly and annual sales for the store in the mathematical formulas
5
00:00:28,580 --> 00:00:29,620
case study.
6
00:00:29,780 --> 00:00:37,500
We have quarterly sales and annual sales in the worksheet already calculated from the previous case
7
00:00:37,500 --> 00:00:38,320
study.
8
00:00:38,610 --> 00:00:46,200
The monthly sales worksheet now has a new column kid which has a quarterly targets for each quarter
9
00:00:46,950 --> 00:00:47,900
for quarter 1.
10
00:00:47,910 --> 00:00:49,770
This is the target for quarter 2.
11
00:00:49,770 --> 00:00:51,360
This is the target.
12
00:00:51,480 --> 00:00:52,610
This is for quarter 3.
13
00:00:53,250 --> 00:00:58,140
This is for quarter for and finally this is their annual sales target.
14
00:00:58,160 --> 00:01:06,530
We will compare their quarterly sales in column J with quarterly sales targets in column K to see if
15
00:01:06,530 --> 00:01:13,150
the store achieved its sales target incident Dec. 21.
16
00:01:13,150 --> 00:01:18,690
We will test if sales target for all of the full quarter.
17
00:01:18,820 --> 00:01:23,050
Team in Sale Dec. 22.
18
00:01:23,120 --> 00:01:37,480
We will test if sales target was achieved in at least one quarter sales L5 in line 13 and 17 day 21
19
00:01:37,510 --> 00:01:42,920
and did 22 have a special formatting that you will notice.
20
00:01:43,030 --> 00:01:46,630
Once we entered the formula and performed that calculation.
1924
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.