# Conditional statements

<table><thead><tr><th width="168">NAME</th><th>DESCRIPTION</th><th data-hidden></th></tr></thead><tbody><tr><td><a href="conditional-statements/if">IF </a></td><td>Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE</td><td></td></tr><tr><td><a href="conditional-statements/ifna">IFNA</a></td><td>Returns the value you specify if a formula returns the #N/A error value; otherwise, it returns the result of the formula</td><td></td></tr><tr><td><a href="conditional-statements/switch">SWITCH</a></td><td>Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value is returned.</td><td></td></tr><tr><td><a href="conditional-statements/filterif">FILTERIF</a></td><td>Returns the list of items that match the given condition</td><td></td></tr></tbody></table>