Conditional statements

Structuring nested IF statements On its own, an IF function can only have two results—either the logical argument is true, or the logical argument is false. Putting an IF function inside of another IF function - called nesting - can make it so that...

Incorporating colorful emoji into conditional (IF) statements in a formula field is a great way to automatically flag records meeting certain conditions. If you have Windows 10, you can bring up an emoji picker by typing windows . or wind...

The IF function will return one of two values depending on whether a logical argument is true or not. This article will cover how to compare a string of text against a logical argument using an IF statement. IF statements (or conditional statem...

The IF function will return one of two values depending on whether a logical argument is true or not. This article will cover how to compare numeric values (numbers) against a logical argument using an IF statement. IF statements (or conditiona...

Compare one date against another Using an IF statement is a quick way to compare two dates. The formula below will compare both dates, and return the second date only if it is greater than the first date, and otherwise show a blank value. ...