Logic in Excel

Содержание и основные понятия

Back to the table of contents
Alterna · Chapter 15 · page 15.3
Logic in Excel
Logical formulas in the table editor: and, or, NES, Ess, practical examples.
== sync, corrected by elderman == @elder_man
Logic machine
Each cell can contain a formula that calculates the value from the other cells, and here we can see how mathematical logic works in practice.
GEF
PIF
Practice
01
Excel Logical Functions
Core functions
Function
Analogies
Example
Result
=И(A1;B1)
A ∧ B
= I(1;1)
SECRET
=ИЛИ(A1;B1)
A ∨ B
= IL(0.1)
SECRET
=НЕ(A1)
¬A
= HE(0)
SECRET
=ЕСЛИ(A1;"да";"нет")
Torn
= SELL(1; "yes"; "no")
Yes
=И(ИЛИ(A1;B1);НЕ(C1))
(A∨B)∧¬C
= I(IL(1;0); NE(0))
SECRET
=ИСТИНА()
1
= SISTINA()
SECRET
=ЛОЖЬ()
0
= LETTER()
LOOK.
Important
In Excel:
И
= AND,
ИЛИ
= OR,
НЕ
= NOT. Arguments through a semi-colon
;
(in Russian loco) or semi-colon
,
(English)
02
Interactive formula calculator
Enter cell values - get the result of the formula
📊
Excel formula calculator
A1
B1
C1
Formula (Russian local)
03
Excel Truth Table
Interactive table: 3 variables, 8 combinations
How to Create an Excel Truth Table
Column A (A2:A9) is all combinations for A: 0.0,0.0,1,1,1,1
In column B (B2:B9) all combinations for B are: 0.01,0.0,1.1.
In column C (C2:C9), all combinations for C are 0.1.0,0,1,0.1.
In column D, the formula:
=И(A2;B2;C2)
(all three)
Select D2, pull it down to D9, the formula is automatically copied!
📋
Interactive table: A, B, C
Formula:
Council
Copy this table in Excel!
04
Practical examples
Example 1: Verification of the assessment
If the student scored ≥ 80 points, "Great," otherwise, "It needs further work."
=ЕСЛИ(A1>=80;"Отлично";"Нужна доработка")
Example 2: Logic Condition
If the temperature > 30 and humidity > 70 is "Dangerous!" or "Norma".
=ЕСЛИ(И(A1>30;B1>70);"Опасно!";"Норма")
Example 3: Enclosed logic
Test classification: ≥ 90 "A", ≥ 70 "B", ≤ 50 "C", otherwise "F".
=ЕСЛИ(A1>=90;"A";ЕСЛИ(A1>=70;"B";ЕСЛИ(A1>=50;"C";"F")))
🧪
Practice: Compute formula