playlistduration

Excel IF Function Formula Tricks

by excelisfun · 97 videos

Total watch time

15h 31m

at 1× speed · exactly 15 hours, 30 minutes, 55 seconds at 1×

1×15h 30m 55s
1.25×12h 24m 44s
1.5×10h 20m 37s
1.75×8h 51m 57s
2×7h 45m 28s
Average video9m 36s
Longest54m 8s
Shortest1m 40s
Compare Open on YouTube JSON

Plan to finish

About 16 days at an hour a day

Pick a daily pace and the days you'll watch. Ticked videos are skipped.

Days

At one hour a day, every day, this playlist takes about 16 days. Turn on JavaScript to plan around your week.

Videos (97)

15h 31m in total · tick what you've watched

Tick videos you've watched — progress is saved in this browser.

Videos to
Watched
1 Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!! 54:08 2017-11-05
2 Highline Excel 2013 Class Video 15: IF & IS Functions To Deliver Numbers, Text, Formulas, Nested IFs 26:17 2013-10-12
3 Excel Magic Trick 939: Use OR and AND Functions In IF Function For Logical Tests 16:31 2012-07-03
4 Highline Excel 2013 Class Video 14: AND, OR, IF Functions For AR Dept (Multiple Logical Tests) 13:37 2013-10-12
5 Excel Magic Trick 1286: Excel 2016 IFS Functions (9 Examples: Compare & Contrast IF & IFS Functions) 28:21 2016-03-03
6 Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples) 12:20 2011-02-05
7 Excel Basics #22: IF function formula made easy! 9:41 2008-12-16
8 Excel Magic Trick 452: IF Function Formula 16 Examples 36:40 2009-11-30
9 Excel Magic Trick 167p1 IF function formula: 12 Examples! 10:31 2008-12-02
10 Excel Magic Trick 167p2 IF function formula: 12 Examples! 10:34 2008-12-02
11 Highline Excel Class 35: IF Function Vs. VLOOKUP Function 7:30 2009-05-13
12 Highline Excel Class 11: Logical formulas, IS & IF functions 27:33 2009-04-05
13 Excel Magic Trick #394: IF Function and Conditional Formatting 5:04 2009-09-26
14 Excel Magic Trick 367: Any Number Not Zero = TRUE 1:40 2009-08-13
15 YouTubersLoveExcel#35: IF AND vs. VLOOKUP 5:30 2008-06-16
16 Excel Magic Trick #113: Nested IF & Short Term Loans 10:22 2008-10-10
17 Excel Magic Trick #129: More than 7 Nested IF functions 4:36 2008-10-17
18 Excel Magic Trick #217: IF Function Text Logical Test 2:50 2009-01-20
19 Excel Magic Trick #145 p1 MEDIAN IF 2:59 2008-10-28
20 Excel Magic Trick #145 p2 MODE IF 4:40 2008-10-28
21 Excel Magic Trick #145 p3 AVERAGE IF before 2007 Excel 2:36 2008-10-28
22 Excel Magic Trick 145 p4 STDEV IF Standard Deviation IF 5:23 2008-10-28
23 YouTubersLoveExcel#13: Date Math and IF function 6:12 2008-04-23
24 YouTubersLoveExcel#22: EOM Terms with IF, DAY & EOMONTH fun 5:14 2008-05-30
25 YouTubersLoveExcel#17: Hide Bank Rec Formula 10:37 2008-05-23
26 YouTubersLoveExcel#22: EOM Terms with IF, DAY & EOMONTH fun 5:14 2008-05-30
27 YouTubersLoveExcel#28: Complex & Amazing Excel Trick 9:45 2008-06-07
28 YouTubersLoveExcel#31: Dates, Cash Flow & Logic 9:27 2008-06-11
29 YouTubersLoveExcel#31: Dates, Cash Flow & Logic 9:27 2008-06-11
30 YouTubersLoveExcel#48: VLOOKUP for TIME 7:38 2008-06-27
31 Excel Magic Trick 99 Instead of IF function use MAX and MIN! 2:48 2008-07-01
32 YTLE#66.5: 3 ways to Hide Formula Errors 7:16 2008-07-24
33 YTLE#66: VLOOKUP replaces IF, Again! 3:06 2008-07-24
34 YTLE#83: Two Or Fewer Decimals Only Into The Cell 9:45 2008-08-07
35 YTLE#84: A Few Data Validation Tricks 8:23 2008-08-07
36 YTLE#95.2: Identifying Customers in Database 5:29 2008-08-12
37 YTLE#100: Array Formula Database Customer Evaluation 8:37 2008-08-13
38 YTLE#111: Excel AVERAGE w Multiple Criteria 4:20 2008-08-30
39 YTL Excel #117: Select Sample Data from List 9:14 2008-09-09
40 YTL Excel #115: Time Delayed Formula TODAY & IF functions 3:38 2008-09-09
41 YTL Excel #125: Array Formula w IF & AVERAGE functions 10:28 2008-09-11
42 YTL Excel #127: AVERAGE When Hurdle Met 2:20 2008-09-17
43 YTL Excel #130: Income Statement from Excel Table: Array For 10:21 2008-09-17
44 Excel Magic Trick #111: Build A Questionnaire 8:02 2008-10-10
45 Excel Magic Trick #117: Reverse 2-Way Lookup Part 1 9:16 2008-10-10
46 Excel Magic Trick #118: Reverse 2-Way Lookup Part 2 5:43 2008-10-11
47 Excel Magic Trick #131: Ranking w MIN IF OFFSET 8:49 2008-10-17
48 Excel Magic Trick #128: VLOOKUP Categories 4:54 2008-10-17
49 Excel Magic Trick #122: Sum With More Than 1 Criteria 9:17 2008-10-17
50 Excel Magic Trick #121: Count With More Than 1 Criteria Condition 7:35 2008-10-17
51 Excel MT142 p2: Array Formula for Counting Dates 10:11 2008-10-28
52 Excel MT 144 p1 Formula: Avoid Data Validation 1 Rule Limit 10:33 2008-10-28
53 Excel MT 144 p2 Formula: Avoid Data Validations 1 Rule Limit 5:20 2008-10-28
54 Excel Magic Trick #147: Dynamic List from Table #2 9:29 2008-11-19
55 Excel Magic Trick #148: Dynamic List from Table #3 10:32 2008-11-19
56 Excel Magic Trick #149: Reverse 2-Way Lookup No Duplicates 9:03 2008-11-19
57 Excel Magic Trick #149.5: Reverse 2-Way Lookup w Duplicates 10:00 2008-11-19
58 Excel Magic Trick #151: DATEDIF function (between two dates) 6:03 2008-11-19
59 Excel Magic Trick #153: Conditional Formatting for Incentive 6:50 2008-11-19
60 Excel Magic Trick # 164: CEILING function in Price Formula 4:14 2008-12-02
61 Excel Magic Trick # 162: LARGE IF & INDEX w 4 Criteria 10:21 2008-12-02
62 Excel Magic Trick # 156: List Of Unique Items w Formula From 2 Lists 8:08 2008-12-02
63 Excel Magic Trick #173: Time Over or Under (Negative Time) 7:57 2008-12-30
64 Excel Magic Trick #183: Income Statement by Year & Month 7:35 2009-01-03
65 Excel Magic Trick #179: Are All Four Word The Same? 4:50 2009-01-03
66 Excel Magic Trick #202: Calculate Vacation Days 4:10 2009-01-09
67 Excel Magic Trick #198: 3 Formulas For Frequency Distribution 6:22 2009-01-09
68 Excel Magic Trick #189: Count Days Not Sunday 5:34 2009-01-09
69 Excel Magic Trick #187: Unique List w Dynamic Formula 9:41 2009-01-09
70 Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria 11:05 2009-01-09
71 Excel Magic Trick 185 Dynamic Formula Extract Data 1criteria 10:12 2009-01-09
72 Excel Magic Trick #203: Sequential Numbers in Formulas ROWS function 6:11 2009-01-16
73 Excel Magic Trick #213: Dynamic Data Extract w Formula 9:20 2009-01-19
74 Excel Magic Trick #245: Matching 2 Lists w IF & OR functions 2:29 2009-02-03
75 Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice 10:07 2009-08-13
76 Excel Magic Trick 100: Instead of Long IF, Use MEDIAN function Commission W Hurdle Calculation 13:58 2010-02-02
77 Excel Magic Trick 590: Nested IF function Convert From Actual Days to Billed Days 5:43 2010-05-03
78 Excel Magic Trick 590: Nested IF function Convert From Actual Days to Billed Days 5:43 2010-05-03
79 Excel Magic Trick 601: VLOOKUP & IF functions for Bonus Based On Years Worked 5:25 2010-05-11
80 Excel Magic Trick 1087: OR & IF Function & Conditional Format: Number Outside Lower & Upper Hurdle 9:41 2014-03-27
81 Excel Magic Trick 1155: IF Function: Checking For Empty Cells (5 Methods) 6:47 2014-11-22
82 Excel Magic Trick 1162: Cell Reference That Point To Empty Cells Evaluate To Zero, IF Function Trick 3:06 2014-11-28
83 Excel & Business Math 28: IF Function, IS Functions & Building a Check Register Other IF Tricks too 31:42 2018-02-16
84 Excel Magic Trick 1511: Array Formula: Get Low Bid From Supplier When Delivery Less Than 20 Weeks 13:28 2018-07-25
85 Excel IF Function. Everything You Need to Know. Excel Magic Trick 1634 17:24 2020-01-23
86 Series Discount Excel Formula. 4 Examples. XLOOKUP or INDEX? Excel Magic Trick 1643 8:55 2020-02-28
87 Stack 2 Columns (Append). INDEX Function or Power Query? Excel Magic Trick 1644. 6:47 2020-03-07
88 OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645 6:35 2020-03-11
89 Sum, Count & Average using an OR Logical Test. Many Cool Formulas. Excel Magic Trick 1647 8:05 2020-03-17
90 Dueling Excel #191: Net Working Hours Spanning Midnight & Weekend with Mr Excel & Excelisfun 17:11 2020-08-14
91 Excel Partial Text Lookup Formulas. Top 5 methods for Fuzzy Lookup. Excel Magic Trick 1691. 9:56 2020-09-21
92 Excel Formula to Count Max Consecutive Items in a Column -FREQUENCY, IF & MAX functions. EMT 1808 4:39 2022-12-12
93 Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819 16:06 2023-02-26
94 Excel Formula to Take a Random Sample: 4 Methods. Excel Magic Trick 1824 7:33 2023-07-06
95 Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866 11:30 2024-09-19
96 Excel Formula for Accounting Bank Reconciliation with IF, ISNUMBER & SUM Functions. EMT 1921. 11:12 2026-01-07
97 Excel SCAN Function Dynamic Spilled Array Formula for Automatic Bank Reconciliation. EMT 1922. 10:54 2026-02-03

Embed a badge

Show the watch time in a README or course description — it links back here and updates itself

Watch time: 15h 31m · 97 videos

Markdown
[![Watch time: 15h 31m · 97 videos](https://playlistduration.com/badge/playlist/PLAD26256BF601D9B5.svg)](https://playlistduration.com/playlist/PLAD26256BF601D9B5)
HTML
<a href="https://playlistduration.com/playlist/PLAD26256BF601D9B5"><img src="https://playlistduration.com/badge/playlist/PLAD26256BF601D9B5.svg" alt="Watch time: 15h 31m · 97 videos" width="210" height="20"></a>

Add ?speed=1.5 to the image URL for the time at that speed, ?label=Course to change the left text, or ?style=flat-square for square corners.

Want the numbers themselves? GET https://playlistduration.com/api/v1/playlist/PLAD26256BF601D9B5 returns them as JSON — free, no key. API docs →

Data from the YouTube Data API as of 2026-09-22 (cached). Private or deleted videos are excluded from totals.