Excel 365 Part 11 – Logical Functions

3 years ago
56
Logical Functions Greater than Greater than/equal to Less than Less than/equal to Equal to Not equal to true false criteria IF Statement

Logical Functions are very useful in identifying and providing multiple outcomes. They can evaluate data and determine several possible answers in making decisions. These decisions relieve you from making mistakes and will allow you to duplicate the formula to many rows. "If" conditions include operators such as Greater Than, Greater Than/Equal To, Less Than, Less Than/Equal To, Equal To, and Not Equal To. The results of these conditions are either true or false. Another set of Logical Functions that are covered will add up many fields based on input criteria such as CountIF, SumIF, and AverageIF functions.

Video Series Part 11 - This is a comprehensive guide to learning Excel from the basics to advanced programming techniques. These videos are labeled in order beginning with Part 1, 2, 3, 4, etc. Each video can be downloaded and freely distributed to anyone desiring to learn Excel in great depth.
Higher Quality Video: www.elearnlogic.com/media/excel365-2-ch3-sec1.mp4

- Click + Rumble if the video was helpful.
- Click Subscribe so you won’t miss out on any new videos.
- Click the Share button so you can help others expand their skills.

Each video provides a great overview of the concepts, but the courseware provides additional details for a better understanding. You will be able to follow along with the courseware while watching this video.

Courseware: Excel 365 - Formulas, Charts, And PivotTables
The courseware is available on Amazon at: https://www.amazon.com/dp/1660221943

Chapter 3 - Logical and Lookup Functions
Section 1: Logical If Functions
Logical Functions are very useful in identifying and providing multiple outcomes. They can evaluate data and determine several possible answers in making decisions. These decisions relieve you from making mistakes. "If" conditions include operators such as Greater Than, Greater Than/Equal To, Less Than, Less Than/Equal To, Equal To, and Not Equal To. The result of these conditions is either true or false. Another set of Logical Functions that are covered will add up many fields based on input criteria such as CountIF, SumIF, and AverageIF functions. The following functions will be covered: IF Statement, Nested IF, IFError, AND, OR, NOT, IFS, Switch, SumIF, CountIF, AverageIF, SumIF 3 Parameters, MAXIFS, MINIFS, SumIFS, AverageIFS, and CountIFS functions.

This Courseware/Video is based on Excel 365 and documents command differences between Excel 2010, Excel 2013, Excel 2016, and Excel 2019.

If you have any questions, please contact: Jeff Hutchinson, Website: http://www.elearnlogic.com, Email: jeffhutch@elearnlogic.com

Loading comments...