Welcome to another very important excellent tutorial.
In this video I'm going to teach you absolute and relative reference in itself.
Let us start our journey with a very simple example.
Let us say I have learned that the word profit for each of these products what I will do is that I will
just go and take the retail price and deduct cost out of it.
But not if I have to apply this profit formula on all of these work.
What I simply need to do I need to copy and paste this formula in.
All of these sales below and Excel will quickly calculate the per property all of these stores if I
can show you any of different columns any of different cells.
I will just rest up to you and you will see that still has taken the drive and called in that line in
that particular line and has the very appropriate exit as smart right.
But what if I have to go through that the downward slide if I have to apply a 10 percent discount I
only have to take 90 percent of the plight of others who is that I will simply take 90 percent good
on one on one time and I will go.
I will take their price and I will click on how it multiplied.
Thus 90 percent so that a 10 percent discount skeptic will see that X has taken the nine people can
offer a price of the real one.
But what if I go to the road.
If I copy and paste this formula and go two you will see that you are seeing a very strange answer here
and the straight answer is if you had taken the line you could not find someone for your answer should
have been something like point six or seven or two point five right.
But on for this venture what it says in fact let me show you how to click on add to other bits of truth
to open the formula.
And you will see that Excel has taken as it has come down in both lines for the retail price.
It has come the low down.
That is okay but also for the for the column.
Key for the 90 percent extra has gone one column down and that should not have been the case.
So what we need to do is that our the to sell and I will go back to the puzzle.
I would go back to Q2 and I will press Apple to open the formula no one should be locked at given it
should not be moved into Q2 guide.
So you will go to give one and you will click I f for button once you press F for You will see that
Excel has somehow lost this formula.
And once you will know that you will copy the issue of formula in the bottom row and you will see that
the first column will be going down X has gone down in the first column right in every single do the
correct price is coming down but if you look at the first.
If you look at the key one that given is locked.
So in every particular rule your discounted price is locked at 90 percent.
So this is called absolute preference so that some will not be going down on one given as an absolute
reference exit as locking down this particular cell at a of formula at Cleveland.
But for the other for the other e for the crude oil price column for the vertical for itself a reference
as an elective reference which means that for every single route Excel will be taking by itself in the
particular well because we are the part of the formula.
So let me go down and copy paste this formula here you will see that like numbers I do you will see
that at first taken the price for this particular group but for the 90 percent discount it has gone
back to given because that formula is an absolute reference and for the retail price the reference is
a relative difference so lives going down for every part of the law.
So these absolute reference and relative reference are very very important concept for business users
and we have to use them very often.
Hope that was helpful.