Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics05.xlsx
Link to full Excel Basics Class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo
pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics05.pdf
In this video learn about logical tests which are the driver behind functions like IF, IFS, AND, OR, NOT, ISNUMBER and more. See 14 examples of logical tests and the IF function and more.
Topics:
1. (
00:00) Introduction
2. (
00:40) Topics in Video
3. (
01:19) IF function and its arguments
4. (
01:56) Logical tests in the Excel worksheet: Complete Story
5. (
08:48) Logical formula using comparative operators, including a comparison to how comparative operators are used in functions like SUMIFS and COUNTIFS
6. (
10:45) Logical formula using ISNUMBER function
7. (
11:55) Logical formula using AND Function
8. (
13:34) Logical formula using case-insensitive formula
9. (
14:05) Logical formula using non-zero numbers as TRUE formula
10. (
15:15) Logical formula using math operator to convert TRUE to 1 and FALSE to 0
11. (
15:46) Use IF function to deliver a sales bonus to a cell
12. (
17:26) Use IF function to deliver the message “Not In Balance” to a cell when Debits do not equal Credits
13. (
20:03) Use IF function to deliver the correct sales commission rate to a formula
14. (
22:00) Use XLOOKUP, IF, and ISNUMBER functions to build an Invoice.
15. (
28:33) Use IF function with the AND function. Also see how to spill the results for an AND Logical Test using the math operator: Multiplication.
16. (
31:36) Use IF function with the OR function. Also see how to spill the results for an OR Logical Test using the math operator: Addition.
17. (
34:26) Use IF function to create a NONE Logical Test using the NOT function.
18. (
36:32) IFS function to put three or more things into a cell
19. (
39:16) IFNA and FORMULTEXT functions
20. (
40:38) IFERROR Function and when not to use it. Scoring template for Boomerang Tournament.
21. (
45:19) Summary
22. (
46:16) Homework – Practice Problems for you!
23. (
46:27) Closing
23.033 Lượt nghe
Video
