0:01
hi everyone and welcome back to Excel
0:03
with in today's video I'm going to show
0:05
you how to keep one cell constant in
0:08
Excel and we'll do so by using this
0:11
example We have three products the
0:14
prices and the total price and we also
0:17
have the quantity which is constant So
0:19
we want to know the total price of each
0:22
laptop So the first thing to start with
0:25
we just have to type in our
0:27
formula which is the price of the laptop
0:30
multiplied by the quantity which is
0:33
sorry the quantity which is
0:35
30 and we get our total price to be
0:39
24,000 USD So normally we'll just drag
0:45
rest but as you can see we are getting
0:51
our our quantity is not constant in the
0:54
formula As you can see on the formula
0:57
bar the first the total price for
0:59
laptops is F6 which is 800 multiplied by
1:04
F_sub_2 which is the quantity So we need
1:08
quantity to be constant as we drag and
1:13
drop uh down the column So what we need
1:17
to do to correct this and to ensure that
1:20
one cell is always constant we are going
1:23
to just click on the first the total
1:26
price here and um in front of your F or
1:32
column add a dollar sign and another
1:37
dollar sign in front of your
1:41
Sorry And then click enter So since
1:46
we've done that as you can see this is
1:48
now the formula that you are going by
1:52
drop it changes So it ensures that your
1:56
F_sub_2 F_sub_2 which is the quantity
1:59
now is constant as you drag down So this
2:03
normally this is how you normally um
2:07
keep one cell constant So just to recap
2:10
the first thing that you need to do is
2:12
you create the formula which we've done
2:15
So here that is by F6 adding the dollar
2:18
sign in front of the column and another
2:21
dollar sign in front of the row And then
2:24
um the third that's the second thing The
2:29
third thing now is to copy the data
2:31
which you've done so and drag down to
2:33
the other cells So if you have any
2:35
questions regarding this please feel
2:38
free to leave a comment in the comment
2:40
section And if you want us to do another
2:43
video different from what we do please
2:46
feel free to tell us in the comment
2:48
section Otherwise as always thank you
2:50
for always watching and I hope you
2:52
benefit from the videos that we do Thank
