If Excel Formula




Excel Formulas > Logical & Reference Functions > IF

« Countif | If | Large »

What is the use of If formula?

Fetches one of the two values based on a condition


Syntax of If formula:
if(is-this-true?, do this, or this)

Examples of Excel If formula:
if(5<10,"hello","world") = hello
if(5>10,"hello","world") = world

Buy Excel Formula E-book | Learn more about Excel If Formula

More Logical & Reference Functions : And | Countblank | Countif | If | Large | Max | Min | Not | Or | Small | Sumif | Vlookup

Mathematical Functions | Text Functions | Logical & Reference Functions
Date & Time Functions | Financial Functions | Information Functions

Microsoft Excel Formula Training - Ebook