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!

 

Question? Ask it in our Excel Forum


Downloadable Files: Excel File