MS Excel – logical calculations

MS Office course designed for employees of the University of South Bohemia. 

Using logical functions for decision making, condition checking, and error handling in calculations.

Introduction to logical functions

• What are logical calculations

• When and why to use them

• Examples of practical use (e.g., evaluation, data checking, selection of variants)

IF function – basic use

• Syntax: =IF(condition; value if TRUE; value if FALSE)

• Types of conditions: comparison of numbers, texts, cells

• Simple decision making: e.g. =IF(A1>100;"above limit";"within normal range")

• Nested IF functions (multiple levels of decision-making)

AND and OR functions – combination of conditions

• AND function: all conditions must be met

• OR function: only one condition needs to be met

• Use in conjunction with IF

Combination of logical functions

• Nested functions: IF + AND + OR

• Logical operations in complex calculations, decision-making based on multiple criteria

IFERROR function – error handling

• Syntax: =IFERROR (expression; value if error)

• Error types: division by zero, non-existent references, incorrect calculation

• Error handling in calculations: =IFERROR(A1/B1;"error")

Mgr. Vendula Mikolášková
This email address is being protected from spambots. You need JavaScript enabled to view it.