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
docs.google.com/spreadsheets/...
✅Section 2: Formula Building
docs.google.com/spreadsheets/...
➡️Section 3: Data Validation
docs.google.com/spreadsheets/...
--
🗣️Socials:
WEBSITE: matttechtidbits.github.io/mat...
REDDIT: / matttechtidbits
LINKEDIN: www.linkedin.com/in/matthew-k...
INSTAGRAM: / matttechtidbits
Need a Freelancer? Check out my Upwork Profile:
www.upwork.com/freelancers/~0...
🎵Music is "WFH" by Ambiosynthesis
• WFH
-
#️⃣
#sheets
#spreadsheet
#googlesheets
#technology
Негізгі бет Ғылым және технология Number Data Validation Rules
Пікірлер