All
Search
Images
Videos
Shorts
Maps
News
More
Shopping
Flights
Travel
Notebook
Report an inappropriate content
Please select one of the options below.
Not Relevant
Offensive
Adult
Child Sexual Abuse
Length
All
Short (less than 5 minutes)
Medium (5-20 minutes)
Long (more than 20 minutes)
Date
All
Past 24 hours
Past week
Past month
Past year
Resolution
All
Lower than 360p
360p or higher
480p or higher
720p or higher
1080p or higher
Source
All
Dailymotion
Vimeo
Metacafe
Hulu
VEVO
Myspace
MTV
CBS
Fox
CNN
MSN
Price
All
Free
Paid
Clear filters
SafeSearch:
Moderate
Strict
Moderate (default)
Off
Filter
exceljet.net
IF with boolean logic
This formula shows how a nested IF formula can be replaced with Boolean logic to sum values based on three conditions. In the example shown, the formula in F5 is: {=SUM(IF((color="red")*(region="East")*(quantity>7),quantity))} where color (B5:B13), region (C5:C13), and quantity (D5:D13) are named ranges. The result is 18, the sum of quantity ...
Oct 26, 2022
Related Products
Boolean Formula Book
Simplifying Boolean Formulas
Boolean Equation Simplification Formula
#Excel IF Function
How to use IF function in Excel
excelexplained.com
Jul 11, 2024
How to use Excel If Statement with Multiple Conditions Range [AND/OR]
spreadsheetplanet.com
Jun 22, 2012
Top videos
6:56
Boolean Expression & Operators | Definition & Application
Study.com
32K views
Dec 22, 2013
9:40
Boolean Algebra Simplification Part 1
YouTube
ElectronX Lab
77.1K views
Jan 21, 2014
13:19
Truth Table to Boolean Expression
YouTube
Steven Miller
115.2K views
Jul 2, 2018
Excel AND, OR, NOT Functions
2:00
Learn Excel logical functions AND, OR, NOT, and XOR with simple examples. These functions are widely used in MIS reports, data validation, and decision-making formulas. Perfect for beginners, office jobs, and data analysis roles. | Brain educator
Facebook
Brain educator
1 month ago
Use AND(), OR(), and NOT() in nested functions - Microsoft Excel Video Tutorial | LinkedIn Learning, formerly Lynda.com
linkedin.com
Mar 20, 2023
6:41
Logical Functions AND, OR, NOT in Microsoft Excel
YouTube
Belad Creative Studio
1 month ago
6:56
Boolean Expression & Operators | Definition & Application
32K views
Dec 22, 2013
Study.com
9:40
Boolean Algebra Simplification Part 1
77.1K views
Jan 21, 2014
YouTube
ElectronX Lab
13:19
Truth Table to Boolean Expression
115.2K views
Jul 2, 2018
YouTube
Steven Miller
4:30
Simplification using the Rules of Boolean Algebra
3K views
Sep 3, 2018
YouTube
Stephen Mendes
11:57
Boolean Expression to Logic and Truth Table
5.1K views
Jul 2, 2018
YouTube
Steven Miller
8:22
Boolean Algebra | Concepts, Rules & Examples
23K views
Sep 11, 2024
Study.com
5:54
What Is Boolean Logic? - Definition, Diagram & Examples
11K views
Apr 7, 2022
Study.com
Boolean operations in array formulas
Oct 27, 2022
exceljet.net
13:50
Boolean Expression Represented as a Truth Table Example 1
130.9K views
Mar 8, 2017
YouTube
Maths and Stats
2:56
Step-by-Step Boolean Algebra Simplification for Beginners 16
690 views
Oct 18, 2022
YouTube
Mathematics First
15:55
De Morgan's Law in Boolean Algebra Explained (with Solved Ex
…
264.7K views
Oct 23, 2021
YouTube
ALL ABOUT ELECTRONICS
12:10
Simplification of Boolean Expression using Boolean Algebr
…
951.8K views
Aug 6, 2020
YouTube
ENGINEERING TUTORIAL
14:11
Simplification of Boolean Expressions
86K views
Mar 11, 2019
YouTube
The Learner's Channel
8:29
Simplify Boolean Expressions using Rules and Laws
50.5K views
Sep 8, 2019
YouTube
Stephen Mendes
19:00
The Laws of Boolean Algebra Explained
221.6K views
Oct 16, 2021
YouTube
ALL ABOUT ELECTRONICS
54:07
Logic Gates, Truth Tables, Boolean Algebra AND, OR, NOT, NAND & N
…
2.8M views
Jan 22, 2021
YouTube
The Organic Chemistry Tutor
Boolean Algebra Simplification Calculator Video Tutorial
28.3K views
Oct 26, 2023
TikTok
hazelbarceta
4:10
10: Absorption Law: Boolean Simplification | WJEC EDUQAS Co
…
5.9K views
Jan 20, 2022
YouTube
LessonHacker
9:57
Simplification of Boolean Expression using Boolean Algebr
…
151K views
Aug 9, 2020
YouTube
ENGINEERING TUTORIAL
3:33
How to use boolean logic in Excel formulas
29.5K views
Dec 1, 2016
YouTube
Exceljet
6:11
Forming a truth table and a boolean expression from a logic circuit (Ex
…
26.4K views
Mar 25, 2023
YouTube
Computing and Maths Tuition by Matthew Xuereb
3:48
Boolean and logic gates
27.3K views
Feb 22, 2016
YouTube
Andrew MASTERS
15:45
Boolean Algebra for PLCs Explained | Basics
6.4K views
Jun 19, 2021
YouTube
Learning Orbis
8:47
Boolean Function Implementation Using CMOS: Circuit, Working, an
…
237.8K views
Aug 17, 2020
YouTube
Engineering Funda
13:41
Boolean Algebra 3 – De Morgan’s Theorem
82K views
Feb 12, 2018
YouTube
Computer Science Lessons
19:05
Boolean Algebra 2 – Simplifying Complex Expressions
200.2K views
Nov 22, 2017
YouTube
Computer Science Lessons
9:32
Boolean Logic - Truth Tables
75.9K views
Apr 11, 2012
YouTube
CatComputerTeacher
18:20
Ep 034: Basic Boolean Algebraic Simplification Examples
20.2K views
Aug 27, 2020
YouTube
Intermation
4:29
De Morgan's Laws / Theorems | Boolean Algebra & Logic Gates
225.8K views
Jun 17, 2016
YouTube
Simple Snippets
See more videos
More like this
Feedback
