How to use Excel IF function
All the basic information regarding Excel IF function is listed in the table below. (This data is regularly updated from Microsoft and several resources)
|Description:||Specifies a logical test to perform|
|Return Value:||The values you supply for TRUE or FALSE|
|Syntax:||=IF (logical_test, [value_if_true], [value_if_false])|
|Applies to:||Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000|
|Other languages:||English: IF
|Portuguese (Brazil): SE
Portuguese (Portugal): SE
All Other Languages: IF
|Related Functions:||COUNTIF, SUMIF, AND, OR|
EXCEL IF FUNCTION DETAILS
Syntax details with an example regarding the correct usage of function can be seen below.
=IF (logical_test, [value_if_true], [value_if_false])
|logical_test||A value or logical expression that can be evaluated as TRUE or FALSE.|
|value_if_true [optional]||The value to return when logical_test evaluates to TRUE.|
|value_if_false [optional]||The value to return when logical_test evaluates to FALSE.|
Check the video below to see How to use IF Formula in Excel with some examples:
LINKS AND RESOURCES
Here we provide a list of useful links which we think can be useful while trying to learn Excel IF statement usage with some examples and tips.
Microsoft Office support page – Excel IF function:
Excel IF function examples and FAQ:
EXCEL FORMULAS TRAINER
As said: Practice Makes Perfect!
Test your Excel skills in Excel itself with our unique product: Excel Formulas Trainer.
30 sections and around 100 questions with full hands-on experience. Progress tracking, dashboard, error checking and many more. Check it now: