Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/if-func…
IF function - Microsoft Support
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. For example, =IF (C2=”Yes”,1,2) says IF (C2 = Yes, then return a 1, otherwise return a 2).
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/using-i…
Using IF with AND, OR, and NOT functions in Excel
How to use the IF function (combined with the AND, OR, and NOT functions) in Excel to make logical comparisons between given values.
Global web icon
microsoft.com
https://support.microsoft.com/en-gb/office/if-func…
IF function - Microsoft Support
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/if-func…
IF function – nested formulas and avoiding pitfalls
Multiple IF functions can be nested together to allow for multiple criteria. The Excel IF function statement allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if True or False.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/create-…
Create conditional formulas - Microsoft Support
Create a conditional formula that results in a logical value (TRUE or FALSE) To do this task, use the AND, OR, and NOT functions and operators as shown in the following example.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/excel
Excel help & learning - support.microsoft.com
Explore how-to articles, guides, training videos, and tips to efficiently use Excel.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/ifs-fun…
IFS function - Microsoft Support
The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition. IFS can take the place of multiple nested IF statements, and is much easier to read with multiple conditions.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/overvie…
Overview of formulas in Excel - Microsoft Support
Master the art of Excel formulas with our comprehensive guide. Learn how to perform calculations, manipulate cell contents, and test conditions with ease.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/Formula…
Formulas and functions - Microsoft Support
Learn these top skills to create your own formulas and functions.
Global web icon
microsoft.com
https://support.microsoft.com/en-us/office/example…
Examples of commonly used formulas - Microsoft Support
The following table contains links to articles and videos that show you how to create formulas from the data in your worksheet. The examples in the articles contain sample data to get you started and guidance to help you get the results you expect.