Make Better IF Statements in Excel - Learn to Convert Complex Formulas into True False Values

Add to Favorites
Author: | Edits: don

How to change any formula to make it return a TRUE or FALSE value - you need this for using IF statements, Data Validation, or Conditional Formatting in Excel.

This Excel tutorial shows you many ways to get any formula to output the boolean values (true/false) so that you can use them to make decisions in Excel. For instance, you can search a list for a value and then do something if the value exists in the list, other than just display or return it and this is what makes this process so powerful.

Once you watch this tutorial, you will be able to transform any formula into a true/false value for use however you like.

The examples in this tutorial include:

  • checking a cell value
  • checking the value for part of a cell
  • verifying cell length
  • looking for specific characters in a cell
  • searching a list to return a value (a vlookup example)

There are many things that you can do with a formula once you convert it to True/False, but this tutorial will focus on getting it to return those boolean values.

I hope you enjoy this tutorial!


Downloadable Files: Excel File

Question? Ask it in our Excel Forum

Our Excel Courses

  • Skill Level: All Levels
  • |
  • 5 hours+

How to make a fully featured professional form in Excel that is unbreakable. This includes how to use the form to store, view, edit, and delete data from a data storage worksheet.

  • Skill Level: All Levels
  • |
  • 2 hours

Send Emails from Excel using VBA and Macros. This course starts from the Basics and builds up to more advanced examples with attaching workbooks, worksheets, PDF's, automatically sending emails, including a signature, error handling, increasing speed, and more.