8.1 Creating Multi-Factor Calculation Using Forms Part 4
8 hours 33 minutes
we're just now going to test if everything here is Okay,
So we're going to click your and start calculation. You're going to get
A and B And let's do this with numbers we know
and let's see calculate. And of course, we get an error.
Uh, because we haven't typed here t every got it as an error throughout
So I have corrected on three
places. You're going to close it close this, closed the bugger
and let's start again. So 34 you see, I'm typing Tab. I'm not moving
the mouse and let's click calculate,
and, uh, we're having another her. Let's just check what it is
So here. One if
then we have another If
just move this. So it's
so this is if this is else
and this is Andy from this if
and then we have this one
and then we have this one
and it should be working. Let's check why this isn't the case,
Okay? Yes. So we had
we had to put one more. If here,
if I think now it's going to be OK. So you see these things are happening and you have to be very careful or you could write it on paper
and then it should be much better. Also, we have here a typo
So these things have to be corrected that everything is going to look nice.
Save it. Let's close it.
We'll stop to the bugger and let's do
and we here we go to five, so everything is fine.
Let's just close this and try to be, uh,
something that is wrong. You need to enter to the miracle values.
And if he enter here minus three and here five
calculate, you can enter only positive numbers. And if we enter here three and here we put nothing. And here we put one and try to calculate we get the message that age has to be greater than a so everything is fine.
And let's see.
Yeah, it tries to do the square because we haven't stopped.
It didn't stop. But it's okay.
We're not going to go into greater details.
We're just going to leave it like this, so it will remind you that something is wrong. It tried to calculate square root from the negative number, which we expected that will happen.
And let's just close this. So the user has been warned
and it's closed. So this one is working perfectly fine. And now we have solved this task. We have successfully done this exercise,
and I strongly encourage you to make a different formula. For example,
like this would be the Maur,
uh, did more. So let's let's make an equation here.
let's, uh, let's make it, for example, this
and, uh but let's make it
a little bit more interesting,
so it's make bigger.
And let's say that a is equal.
a plus B plus c closed this and then divided by
three. Not a but sorry
Ah B plus
So we have four. And again we can have just one that is empty
so you can exercise with this so it will have more complex structure because now we have four fields and three have to be filled. But if you have time and well, I strongly suggest to try to write the macro that will
calculate this so you will enter three
and it will give you the fourth.
So that's it for the *** essays or this example,
and let's continue to the next one
Data Analyst Excel
The Data Analyst Excel Test is a premium Cybrary assessment created by iMocha and intended ...
Monitor a Web App
In this IT Pro challenge, participants get hands-on experience activating server logging and using Application ...
Learn On Demand