Number Data Validation Rules

In this video we work through the Number Data Validation Rules! This covers both Dates and Numbers. Similarly to the Text Data Validation Rules, there's a formula to mimic the TRUE/FALSE rules Data Validations Use.

⏳Timestamps:
00:00 Introduction
01:12 Is Valid Date
01:47 Date Is
02:31 Date Is Before
03:09 Date is On or Before
03:41 Date is After
04:01 Date is On or After
04:22 Date is Between
06:41 Date is Not Between
07:12 Number Validations Greater Than
07:34 Greater Than or Equal To
07:44 Less Than
08:03 Less Than or Equal To
08:27 Is Equal To
08:47 Is Not Equal To
08:58 Is Between
09:15 Is Not Between
9:26 Use a Cell Reference Instead of Hard Coding a Number
11:03 Formulas to Consider For Dates
16:15 Formulas to Consider For Numbers
17:39 When to use Data Validations Vs. Functions
19:30 Conclusion and Challenge
21:14 End Slides

--
✅Section 1: Organization

✅Section 2: Formula Building

➡️Section 3: Data Validation
--

🗣️Socials:

Need a Freelancer? Check out my Upwork Profile:

🎵Music is "WFH" by Ambiosynthesis
—

#️⃣
#sheets
#spreadsheet
#googlesheets
#technology