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 the IF function in Excel
YouTube
Oct 4, 2018
How to Use IF Function in Excel (Step by Step)
YouTube
Jun 2, 2020
Top videos
6:56
Boolean Expression & Operators | Definition & Application
Study.com
32K views
Dec 22, 2013
13:19
Truth Table to Boolean Expression
YouTube
Steven Miller
115.2K views
Jul 2, 2018
8:22
Boolean Algebra | Concepts, Rules & Examples
Study.com
24K views
Sep 11, 2024
Excel AND, OR, NOT Functions
5:31
The Excel FORECAST Function
YouTube
Technology for Teachers and
752.1K views
Oct 5, 2020
5:52
The Excel TRANSPOSE Function
YouTube
Technology for Teachers and
464.2K views
Dec 7, 2020
4:23
Sensitivity Analysis - Microsoft Excel
YouTube
Eric Andrews
1.2M views
Aug 3, 2016
6:56
Boolean Expression & Operators | Definition & Application
32K views
Dec 22, 2013
Study.com
13:19
Truth Table to Boolean Expression
115.2K views
Jul 2, 2018
YouTube
Steven Miller
8:22
Boolean Algebra | Concepts, Rules & Examples
24K 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
4:04
XNOR Gate in Boolean Algebra with Truth Table and Equation
121.9K views
Feb 5, 2018
YouTube
Simple Snippets
11:11
Simplification of Boolean Expression using Boolean Algebr
…
115.9K views
Aug 5, 2020
YouTube
ENGINEERING TUTORIAL
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
85.2K 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
1:34:46
Logic Gates & Minimisation of Boolean Functions | Digital Circuit
…
1.7K views
Sep 1, 2022
byjus.com
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
9:57
Simplification of Boolean Expression using Boolean Algebr
…
151K views
Aug 9, 2020
YouTube
ENGINEERING TUTORIAL
9:59
Simplification of Boolean Expression Using Boolean Algebr
…
104.3K views
Aug 10, 2020
YouTube
ENGINEERING TUTORIAL
6:11
Forming a truth table and a boolean expression from a logic circuit (Ex
…
26.2K views
Mar 25, 2023
YouTube
Computing and Maths Tuition by Matthew Xuereb
3:33
How to use boolean logic in Excel formulas
29.5K views
Dec 1, 2016
YouTube
Exceljet
3:48
Boolean and logic gates
27.3K views
Feb 22, 2016
YouTube
Andrew MASTERS
13:41
Boolean Algebra 3 – De Morgan’s Theorem
82K views
Feb 12, 2018
YouTube
Computer Science Lessons
11:38
Truth Tables Tutorial (part 1)
833.2K views
Jun 24, 2016
YouTube
LearnYouSomeMath
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
4:29
De Morgan's Laws / Theorems | Boolean Algebra & Logic Gates
224.5K views
Jun 17, 2016
YouTube
Simple Snippets
10:59
Ep 030: Introduction to Boolean Algebra
14.6K views
Aug 26, 2020
YouTube
Intermation
11:00
De Morgan's theorem in Boolean algebra | De Morgan's theorem ex
…
22.9K views
Apr 28, 2024
YouTube
Learning Vibes
6:22
Find Boolean Equation and Truth Table from Logic Diagram
68.9K views
Nov 16, 2019
YouTube
Stephen Mendes
14:54
Boolean Algebra 1 – The Laws of Boolean Algebra
546.6K views
Aug 30, 2017
YouTube
Computer Science Lessons
10:49
Determining Boolean Output of a Logic Circuit | Conceptual Questio
…
34.5K views
Oct 7, 2020
YouTube
ENGINEERING TUTORIAL
See more videos
More like this
Feedback