1 00:00:13,960 --> 00:00:14,650 Hi, everyone. 2 00:00:14,860 --> 00:00:23,500 Today, we are going to learn how to write combined operations and using multiple operators to make 3 00:00:23,500 --> 00:00:24,070 a function. 4 00:00:24,280 --> 00:00:30,220 So here we have two different example example to create formula. 5 00:00:30,220 --> 00:00:37,000 And the formula key formula is term of only one variable, and this variable is X. 6 00:00:37,300 --> 00:00:44,200 The formula is function of two variables, and these variables are X and Y. 7 00:00:44,320 --> 00:00:53,050 OK, let's calculate the terms of K and term of Z using these questions. 8 00:00:53,290 --> 00:01:00,980 And what if the final value of K and final value of the if X equal to and Y equals three. 9 00:01:01,510 --> 00:01:04,420 Let's get started and use Microsoft Excel sheet. 10 00:01:05,080 --> 00:01:09,370 And the question is how to write this formula using Microsoft Excel. 11 00:01:09,730 --> 00:01:12,370 First thing is to write equals sign. 12 00:01:13,240 --> 00:01:23,290 Second thing is to open two parentheses and after that you will write the first term X plus three X 13 00:01:24,100 --> 00:01:25,060 and the X. 14 00:01:25,060 --> 00:01:29,640 Here is this reference plus three. 15 00:01:30,880 --> 00:01:36,080 And after that we want to divide X plus three by five. 16 00:01:36,250 --> 00:01:41,170 So to make division, you must open two parentheses. 17 00:01:42,660 --> 00:01:52,530 If you don't open to parentheses and write forward slash and five, this is will calculate only three 18 00:01:52,530 --> 00:02:00,040 divided by five, but you want to divide all the term X plus three by the five. 19 00:02:00,390 --> 00:02:03,300 So you should of into parentheses. 20 00:02:08,360 --> 00:02:20,480 And here is the result of this step is one, if you remove two parentheses, the result will be completely 21 00:02:20,480 --> 00:02:20,990 different. 22 00:02:22,070 --> 00:02:32,630 So two point six, so you must open to parentheses if you want to divide this term by if you want to 23 00:02:32,630 --> 00:02:34,280 divide this term by five. 24 00:02:34,310 --> 00:02:34,640 OK. 25 00:02:34,820 --> 00:02:35,190 OK. 26 00:02:36,020 --> 00:02:44,180 After that, we want to make square and and bar this term by two. 27 00:02:44,480 --> 00:02:50,150 So shift six and right to press enter. 28 00:02:51,200 --> 00:02:56,120 And here is the final result of K based on X equal to. 29 00:02:57,050 --> 00:03:00,260 And the answer will be just sine equal. 30 00:03:00,530 --> 00:03:06,410 And this formula, the answer will be one and the formula will be like that. 31 00:03:06,670 --> 00:03:06,990 OK. 32 00:03:07,300 --> 00:03:07,640 OK. 33 00:03:08,810 --> 00:03:17,750 Also if you want to update the X variable and use another number, say you want to use 100. 34 00:03:19,770 --> 00:03:26,670 Once you press enter, the formula will be updated and the answer will be updated according to the new 35 00:03:26,670 --> 00:03:28,920 value of X like that. 36 00:03:29,820 --> 00:03:30,240 OK. 37 00:03:30,610 --> 00:03:38,250 OK, let's go to the next example and calculate the term of Z and Z here. 38 00:03:38,600 --> 00:03:45,060 A function of two variables of the first variable is X and second variable is one. 39 00:03:45,300 --> 00:03:49,260 Let's say that the variable of Y equals twenty. 40 00:03:49,750 --> 00:03:50,940 OK, ok. 41 00:03:53,300 --> 00:04:03,500 And we want to write the formula, and the first step is to write equal sign and up into parentheses, 42 00:04:04,460 --> 00:04:07,730 and this is minus, this is minus. 43 00:04:07,730 --> 00:04:20,360 We can write minus sign outside the parentheses like that and write one plus reference to Y reference 44 00:04:20,360 --> 00:04:21,020 to Y here. 45 00:04:22,100 --> 00:04:34,280 And you must open to parentheses to divide the term of Y plus one plus Y divided two X minus Y and up 46 00:04:34,280 --> 00:04:44,230 into parenthesis and write that lower tier X and this is reference for X minus Y. 47 00:04:44,330 --> 00:04:46,180 And this is a reference for Y. 48 00:04:46,280 --> 00:04:47,270 OK, OK. 49 00:04:48,260 --> 00:04:55,020 And after that there is a second term here and this term is X squared. 50 00:04:55,460 --> 00:05:00,220 So the first letter here, multiply it by X squared. 51 00:05:00,920 --> 00:05:06,110 So you must open Outr to Bernice's here. 52 00:05:08,500 --> 00:05:18,160 And multiply this term by X Square and this is the reference for X Square and shift six. 53 00:05:20,790 --> 00:05:32,610 And right to so our formula now are completed, and once you press enter, the final result will be 54 00:05:32,640 --> 00:05:37,950 appeared and here is our final result, right. 55 00:05:37,950 --> 00:05:43,160 Equal to hear this reference to show answer. 56 00:05:43,350 --> 00:05:55,410 OK, once you change whoI by 1000, say 1000, the formula and the answer will be updated automatically. 57 00:05:56,900 --> 00:05:59,930 So if you want to change X by. 58 00:06:00,920 --> 00:06:11,260 Two and change Y by three, that K value will be won and the value will be sixteen. 59 00:06:11,630 --> 00:06:15,110 And this is the answer of our quiz today. 60 00:06:18,370 --> 00:06:27,280 This is a picture today, if you want any assistance or any help, please contact us and you can contact 61 00:06:27,280 --> 00:06:34,760 us using Q&A Udemy Smart or Excel Group or our email or our LinkedIn account. 62 00:06:35,470 --> 00:06:36,030 Thank you. 63 00:06:36,040 --> 00:06:37,630 And see you in the next lecture. 64 00:06:37,660 --> 00:06:38,140 Thank you.