×
Create CV Books Summaries Online Courses Blog Communities

Login

Sign up
MindLuster Logo
Categories
Recent

Join Our Telegram Channel Now to Get Any New Free Courses : Click Here

IF Function with Partial Match on Text String or Contains Criteria

Share your inquiries now with community members Click Here
Previous Lesson Next Lesson
Sign Up and Get Free Certificate
Sign up Now
Lesson extensions

Lessons List | 31 Lesson
How to Perform an Excel IF GREATER Than LESS Than Formula
00:06:32

How to Perform an Excel IF GREATER Than LESS Than Formula
Excel If Cell Contains ONE of MANY THINGS
00:05:57

Excel If Cell Contains ONE of MANY THINGS
How to Test IF Cell CONTAINS TEXT Excel Tutorial
00:02:42

How to Test IF Cell CONTAINS TEXT Excel Tutorial
Write an IF Statement for Dates Between Two Dates Date Range
00:07:20

Write an IF Statement for Dates Between Two Dates Date Range
IF Statement in Excel Based on Cell Colour
00:06:08

IF Statement in Excel Based on Cell Colour
Excel IF Function MULTIPLE CRITERIA IF ELSE Function Nested IF Function
00:10:01

Excel IF Function MULTIPLE CRITERIA IF ELSE Function Nested IF Function
If Cell is Blank Then Return Value or Blank in Excel
00:04:48

If Cell is Blank Then Return Value or Blank in Excel
How to Perform Logical Tests in Excel for IF Functions
00:10:36

How to Perform Logical Tests in Excel for IF Functions
IF Function with Partial Match on Text String or Contains Criteria
00:03:07

IF Function with Partial Match on Text String or Contains Criteria
IF Function with Multiple Partial Match Text String Criteria
00:07:10

IF Function with Multiple Partial Match Text String Criteria
Excel s IFS Function Easier Than a Nested IF
00:03:29

Excel s IFS Function Easier Than a Nested IF
How to do an IF VLOOKUP IF and VLOOKUP Nested Function IF TRUE Return Value From Another Column
00:10:17

How to do an IF VLOOKUP IF and VLOOKUP Nested Function IF TRUE Return Value From Another Column
Due Date Pop up Alert in Excel Date Due Tracker Formula Due Date Color Change Notifications
00:10:50

Due Date Pop up Alert in Excel Date Due Tracker Formula Due Date Color Change Notifications
Excel Automatically Sort When Data Changes or Added Auto Sort Excel Formula Auto Sort Macro
00:14:57

Excel Automatically Sort When Data Changes or Added Auto Sort Excel Formula Auto Sort Macro
Excel IF Date is Before or After Another Date IF Date is Before or After Today
00:06:15

Excel IF Date is Before or After Another Date IF Date is Before or After Today
Create an Excel Drop Down List Including an IF STATEMENT Conditional Drop Down List
00:03:24

Create an Excel Drop Down List Including an IF STATEMENT Conditional Drop Down List
Excel IF Range Contains Value How to Perform an IF Statement on a Range
00:04:10

Excel IF Range Contains Value How to Perform an IF Statement on a Range
How to Ignore Formula Not Calculate If Cell is Blank in Excel
00:06:25

How to Ignore Formula Not Calculate If Cell is Blank in Excel
If Time is Within Range If Time is Greater Than or Less Than Return Value Lookup Time in Range
00:14:45

If Time is Within Range If Time is Greater Than or Less Than Return Value Lookup Time in Range
IF and VLOOKUP Nested Function VLOOKUP with a Drop down VLOOKUP with a Condition
00:13:51

IF and VLOOKUP Nested Function VLOOKUP with a Drop down VLOOKUP with a Condition
Concatenate IF TEXTJOIN IF Concatenate IF Cell Contains Text Concatenate with IF Condition
00:04:05

Concatenate IF TEXTJOIN IF Concatenate IF Cell Contains Text Concatenate with IF Condition
IF Value Is Within Tolerance Level Formula Conditionally Format Within or Outside Tolerance
00:03:11

IF Value Is Within Tolerance Level Formula Conditionally Format Within or Outside Tolerance
Excel Automatically Date and Time Stamp When Data is Entered but Don t Change When Data is Modified
00:09:46

Excel Automatically Date and Time Stamp When Data is Entered but Don t Change When Data is Modified
Excel IF Statement If Number is Between Two Values Between Function in Excel
00:03:49

Excel IF Statement If Number is Between Two Values Between Function in Excel
Automatically Update Data in Another Excel Worksheet or Workbook 3 Methods
00:17:57

Automatically Update Data in Another Excel Worksheet or Workbook 3 Methods
List All Dates Between Two Dates in Excel One VBA Macro Method and Two Formula Methods
00:08:17

List All Dates Between Two Dates in Excel One VBA Macro Method and Two Formula Methods
Excel Subtract IF Subtract If Not Blank If Match Then Subtract Subtract If Cell Contains Text
00:04:06

Excel Subtract IF Subtract If Not Blank If Match Then Subtract Subtract If Cell Contains Text
IF Function Excel With Multiple Conditions Nested IF IFS Function IF with 2 or More Conditions
00:09:03

IF Function Excel With Multiple Conditions Nested IF IFS Function IF with 2 or More Conditions
AND Function in Excel OR Function in Excel How to Use IF AND Statement IF OR IF AND OR
00:09:36

AND Function in Excel OR Function in Excel How to Use IF AND Statement IF OR IF AND OR
How to Create Reminders in Excel Due Date Reminder Formula Conditionally Format Before Expired
00:08:54

How to Create Reminders in Excel Due Date Reminder Formula Conditionally Format Before Expired
IF Cell or Font is Colour X eg Red Then Return Value or Formula Cell Colour Formula Excel
00:07:18

IF Cell or Font is Colour X eg Red Then Return Value or Formula Cell Colour Formula Excel

Comments

Our New Certified Courses Will Reach You in Our Telegram Channel
Join Our Telegram Channels to Get Best Free Courses

Join Now

We Appreciate Your Feedback

Be the First One Review This Course

Excellent
0 Reviews
Good
0 Reviews
medium
0 Reviews
Acceptable
0 Reviews
Not Good
0 Reviews
0
0 Reviews


Related Courses in Computer Softwares
Excel Power Query
41 Lessons

Excel Power Query

Excel VBA
36 Lessons

Excel VBA

Excel Dashboard
21 Lessons

Excel Dashboard

Excel Course Basic to Advanced
26 Lessons

Excel Course Basic to Advanced

Excel Functions
66 Lessons

Excel Functions

Excel Charting
18 Lessons

Excel Charting

Microsoft Access
23 Lessons

Microsoft Access

Microsoft PowerPoint
52 Lessons

Microsoft PowerPoint

Microsoft Word
46 Lessons

Microsoft Word

Microsoft Excel
49 Lessons

Microsoft Excel

Digital Media Literacy
15 Lessons

Digital Media Literacy

Google Classroom
5 Lessons

Google Classroom

Google Slides
18 Lessons

Google Slides

Google Sheets Full data
15 Lessons

Google Sheets Full data

Google Docs
34 Lessons

Google Docs

Google Drive
11 Lessons

Google Drive

Course Description

Excel IF function course, in this course we will learn about the Excel IF function, a fundamental tool for performing logical tests and making decisions within your spreadsheets. Starting with the basics, we will explore how to use the IF function to evaluate conditions and return specific values based on whether the conditions are true or false. You'll learn to construct simple IF statements, such as =IF(A1>10, "Yes", "No"), which can help in tasks like grading, categorizing data, and flagging errors. As we progress, we will delve into more advanced techniques, including nested IF statements for handling multiple conditions, combining IF with other logical functions like AND, OR, and NOT, and using IF functions with text, numbers, and dates. We will also cover practical applications, such as error handling, data validation, and conditional formatting, to enhance your data analysis and reporting capabilities. By the end of this course, you will be proficient in using the Excel IF function to create dynamic and responsive spreadsheets, enabling you to analyze and manage data more effectively. Join us to master the IF function and unlock its full potential in your Excel projects.
Trends
Recent
Previous Lesson Next Lesson