0:00
hi everyone today we'll learn how to use
0:02
data validation to ensure that the sum
0:04
of your grocery budget items does not
0:06
exceed the amount you have available
0:08
let's get started here we have a simple
0:10
grocery budget worksheet we have our
0:12
grocery items in the range B1 to B6 the
0:15
available amount is in cell B8 and the
0:17
total budgeted amount is calculated in
0:19
cell B7 our goal is to prevent any entry
0:22
in the grocery items that would cause
0:24
the total in cell B7 to exceed the
0:26
available amount in cell
0:28
B8 first first let's select the range B1
0:31
to B6 where we want to apply the data
0:33
validation rule next go to the data tab
0:36
on the ribbon and click on data
0:38
validation in the data validation
0:40
dialogue box set the allow field to
0:42
custom now we'll enter our custom
0:44
formula this formula will ensure that
0:46
the total of the grocery items does not
0:48
exceed the available amount this formula
0:51
checks if the sum of the grocery items
0:52
in the range is less than or equal to
0:55
the available amount in cb8 next go to
0:58
the error alert tab in the data valid
1:00
dialog box here we can customize the
1:02
error message that will appear if
1:04
someone tries to enter a value that
1:05
exceeds the available amount click okay
1:08
to apply the data validation Rule now
1:11
let's test our data validation rule try
1:13
entering values in the grocery items
1:14
range that would cause the total in B7
1:17
to exceed the available amount in B8 you
1:19
should see the error message we set up
1:21
preventing the entry and ensuring our
1:23
grocery budget stays within the
1:24
available amount perfect the data
1:27
validation rule works as expected and
1:29
that's how you can use data validation
1:31
in Excel to ensure that the sum of your
1:33
grocery budget items does not exceed the
1:35
amount you have available thanks for
1:37
watching if you found this tutorial
1:38
helpful don't forget to like subscribe
1:41
and click the Bell icon for more Excel
1:43
tips and tricks see you in the next
