Logical Expressions and Functions

In this video we look at some Logical Expressions, Functions, and use cases to account for different salary bonuses from multiple criteria. Logical formulas play important roles in data cleaning, grouping, and for conditional formatting rules. We will look at a few functions to use and practice setting up a raise by departments and sizes. -- Current Section: ➡️Section 6: Functions https://docs.google.com/spreadsheets/d/1yXw6KFj5JrPHBuAHHpHzSB4JZfvhxcJ6KEBsUiHTL5Y/copy Previous Sections: ✅Section 1: Organization https://docs.google.com/spreadsheets/d/1SbRW5LJS5P1A5ZA1hxZv3Hnv3bos-dl-e0F96KCuLrA/copy ✅Section 2: Formula Building https://docs.google.com/spreadsheets/d/1nQF5cN3F_QienoZ2hK87L_xoC0Rc8apNrm7PVA5LaHo/copy ✅Section 3: Data Validation https://docs.google.com/spreadsheets/d/1kA9gqFX1d-tAA-y6vWUHAtS9xglwCOAx2XuHodrkkJc/copy ✅Section 4: Sharing https://docs.google.com/spreadsheets/d/1cqc0-arYUW-lLGnhkr4mrcwarRupyavHjJ4c6RmDfCE/copy ✅Section 5: Numbers https://docs.google.com/spreadsheets/d/1FsoYxdQImDyBMHcqtqw0NBhQbQcPNyg67tXYd8qw0gs/copy -- 🗣️Socials: WEBSITE: https://matttechtidbits.github.io/matttechtidbits/ REDDIT: https://www.reddit.com/user/MattTechTidbits INSTAGRAM: https://www.instagram.com/matttechtidbits/ Need a Freelancer? Check out my Upwork Profile: https://www.upwork.com/freelancers/~01e15eefe1443fcea1 – ⏳Timestamps: (00:00) Introduction (00:21) IF() vs. IFS Function (01:03) OR() Function (02:00) AND() Function (02:40) NOT() Function (02:52) Comparison Operators (03:31) Using Logical Expressions to Calculate Raises (04:08) IFS() and Comparison Operators to Calculate Department Size (05:09) Order Matters in IFS()! (07:02) Calculating Bonuses Based on Multiple Criteria (10:46) Adding a Bonus Percentage to Salary (12:00) Double Check to Confirm Formula is Working Properly (12:26) Conclusion & Challenge Task Preview (14:05) End Slides 🎵Music is "WFH" made by me with my solo music project name, @Ambiosynthesis https://www.youtube.com/watch?v=sKi5cGTQoBM — Tags: #googlesheets #spreadsheet #technology #sheets