Fraud Blocker
Announcement bar drops down here to inform users of the latest news and sales!

Business microlearning from Japan’s No1 MBA

Edge

Excel Functions & Formulas: Logical Functions

00h 20m (1 section)

Course Description

Logical functions are powerful tools for decision-making as they test whether a situation is true or false.
They perform calculations on cell contents and compare the results against specific criteria.

This course covers how to:
• Apply IF, AND, OR and NOT to verify whether a condition is met
• Use several comparison operators, including equal to (=), greater than (>), less than (<), and not equal to (),
• Use the OR function and integrate it into IF function,
• Set up the IFS function and incorporate multiple conditions,
• Use the SEARCH, FIND, and ISNUMBER functions to perform case-sensitive and case-insensitive searches,
• Use the SWITCH function to set up the required conditions and output values,
• Use the ISBLANK function or IF function to check whether a cell is blank,
• And, use the ABS function to find the absolute value of a number

Join us, and explore how logical functions handle data for more efficient and accurate decision-making.

Share this course:

Start your free trial

Sign up to watch the rest of this course for free - no strings attached!
Continue with a subscription of USD 16.67 / month* after free trial ends
*USD 99.99 billed every 6 months