IF function basics Conditional statements, conditional expressions, conditional processing, IF-THEN, or IF-THEN-ELSE are all names for a programming concept where conditions are tested and actions are performed if conditions are met. If a certain condition is met, something is calculated. If that certain condition is not met, either nothing happens or something else is calculated. In Excel, when conditions are met, something is TRUE. When conditions are not met, something is FALSE. TRUE and FALSE are logical values. You will …
Tag: ISTEXT function
Text in Excel
Text-related features Excel may have a reputation for crunching numbers, but text-formatted data such as names, addresses, and descriptions is often encountered. Excel is also often used for processing data from a wide variety of unrelated databases, applications, and web sites. With those, issues such as numbers formatted as text, text formatted as numbers, multiple text fields combined into a single cell, and broken tables are not uncommon. Further complicating things, Excel functions designed to manipulate text-formatted data are many, …