playlistduration

Excel Boolean Logic Tricks

by excelisfun · 18 videos

Total watch time

2h 43m

at 1× speed · exactly 2 hours, 42 minutes, 42 seconds at 1×

1×2h 42m 42s
1.25×2h 10m 10s
1.5×1h 48m 28s
1.75×1h 32m 58s
2×1h 21m 21s
Average video9m 2s
Longest23m 32s
Shortest2m 59s
Compare Open on YouTube JSON

Plan to finish

About 3 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 3 days. Turn on JavaScript to plan around your week.

Videos (18)

2h 43m in total · tick what you've watched

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

Videos to
Watched
1 Excel Magic Trick 651: Comparative Operators & Logical Formulas 4:59 2010-07-17
2 Excel Magic Trick 652: Boolean Logic for Logical & Array Formulas 11:34 2010-07-17
3 Excel Magic Trick 653: Boolean Math Bonus Instead of IF Function 3:07 2010-07-17
4 Excel Array Formula Series #7: Boolean Logic & Criteria 10:05 2008-06-26
5 Excel Magic Trick #145 p1 MEDIAN IF 2:59 2008-10-28
6 Excel Magic Trick #145 p2 MODE IF 4:40 2008-10-28
7 Excel Magic Trick 145 p4 STDEV IF Standard Deviation IF 5:23 2008-10-28
8 Excel Magic Trick #122: Sum With More Than 1 Criteria 9:17 2008-10-17
9 Excel Magic Trick #121: Count With More Than 1 Criteria Condition 7:35 2008-10-17
10 Excel Formula Efficiency 1: SUMPRODUCT function 12 Examples 14:00 2009-02-24
11 You Tubers Love Excel#11: Pivot Table, SUMPRODUCT & SUMIFS 8:09 2008-04-17
12 Excel Magic Trick #232: Add w 3 Criteria OR 2 Criteria 11:34 2009-01-28
13 Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples) 8:13 2010-09-03
14 Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution 7:18 2010-09-03
15 Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter 23:32 2010-09-03
16 Mr Excel & excelisfun Trick 148: Logical Formula: 3 Out Of 4 Tests Are Met, Deliver a TRUE 5:29 2014-01-03
17 Excel Magic Trick 1097: AND & OR Criteria Together for Counting, Adding, Conditional Formatting 8:38 2014-04-11
18 Excel Magic Trick 1101: Calculate MEDIAN Based On Lower/Upper Date, Exclude Holidays & Weekends 16:10 2014-04-21

Embed a badge

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

Watch time: 2h 43m · 18 videos

Markdown
[![Watch time: 2h 43m · 18 videos](https://playlistduration.com/badge/playlist/PL711948E9C292480B.svg)](https://playlistduration.com/playlist/PL711948E9C292480B)
HTML
<a href="https://playlistduration.com/playlist/PL711948E9C292480B"><img src="https://playlistduration.com/badge/playlist/PL711948E9C292480B.svg" alt="Watch time: 2h 43m · 18 videos" width="203" 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/PL711948E9C292480B 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.