Hi, everyone.
Today, we are going to learn how to write combined operations and using multiple operators to make
a function.
So here we have two different example example to create formula.
And the formula key formula is term of only one variable, and this variable is X.
The formula is function of two variables, and these variables are X and Y.
OK, let's calculate the terms of K and term of Z using these questions.
And what if the final value of K and final value of the if X equal to and Y equals three.
Let's get started and use Microsoft Excel sheet.
And the question is how to write this formula using Microsoft Excel.
First thing is to write equals sign.
Second thing is to open two parentheses and after that you will write the first term X plus three X
and the X.
Here is this reference plus three.
And after that we want to divide X plus three by five.
So to make division, you must open two parentheses.
If you don't open to parentheses and write forward slash and five, this is will calculate only three
divided by five, but you want to divide all the term X plus three by the five.
So you should of into parentheses.
And here is the result of this step is one, if you remove two parentheses, the result will be completely
different.
So two point six, so you must open to parentheses if you want to divide this term by if you want to
divide this term by five.
OK.
After that, we want to make square and and bar this term by two.
So shift six and right to press enter.
And here is the final result of K based on X equal to.
And the answer will be just sine equal.
And this formula, the answer will be one and the formula will be like that.
OK.
Also if you want to update the X variable and use another number, say you want to use 100.
Once you press enter, the formula will be updated and the answer will be updated according to the new
value of X like that.
OK.
OK, let's go to the next example and calculate the term of Z and Z here.
A function of two variables of the first variable is X and second variable is one.
Let's say that the variable of Y equals twenty.
OK, ok.
And we want to write the formula, and the first step is to write equal sign and up into parentheses,
and this is minus, this is minus.
We can write minus sign outside the parentheses like that and write one plus reference to Y reference
to Y here.
And you must open to parentheses to divide the term of Y plus one plus Y divided two X minus Y and up
into parenthesis and write that lower tier X and this is reference for X minus Y.
And this is a reference for Y.
OK, OK.
And after that there is a second term here and this term is X squared.
So the first letter here, multiply it by X squared.
So you must open Outr to Bernice's here.
And multiply this term by X Square and this is the reference for X Square and shift six.
And right to so our formula now are completed, and once you press enter, the final result will be
appeared and here is our final result, right.
Equal to hear this reference to show answer.
OK, once you change whoI by 1000, say 1000, the formula and the answer will be updated automatically.
So if you want to change X by.
Two and change Y by three, that K value will be won and the value will be sixteen.
And this is the answer of our quiz today.
This is a picture today, if you want any assistance or any help, please contact us and you can contact
us using Q&A Udemy Smart or Excel Group or our email or our LinkedIn account.
Thank you.
And see you in the next lecture.
Thank you.