Excel IF (formula)
The IF function is one of the most important applications in Microsoft Excel. Therefore, every user of Excel should know how to use the IF function. The IF function allows checking different conditions in a worksheet and can output different values depending on the result of the check. For this reason, the IF function is one of the logic functions in Microsoft Excel. It should be noted that the function can be nested and thus can be checked for different conditions in one function. In this context, the If function is also used again and again with the AND, OR and NOT functions, each of which we have explained in a separate article.
Examples of use of the IF formula in Excel:
|If A1 greater than 5, then “Super”, otherwise “Too little”||=IF(A1>5,”Super”,”Too little”)|
|Nested IF function||=IF(A1=1, “Very good”,IF(A1=2, “Good”,IF(A1=3, “Ok”,”You need to study more))|
|IF AND function||=IF(AND(A1>20,B1>20),”Over 40″,”Maximum 40″)|
|IF OR function||=IF(OR(A1=2,B1=2), “Min. one 2″,”No 2”)|
|Necessary condition to be checked|
|Output value if the result of the check is true|
|Value output if the result of the check is false|
If you want to work successfully with Microsoft Excel, you cannot avoid using the IF function. Although there are certainly work-arounds, in most cases these require significantly more time and also space in the worksheet, so that it is not worthwhile to use them. Likewise, alternative work-arounds can rarely scale and transfer machining appropriately. If you have any further questions about the IF function, our YouTube video, which explains the application in more detail, will certainly help you.
Links with * are affiliate links. By purchasing via this link we receive a part of the purchase price as commission without any additional costs for you. This helps us to expand the offers available here for you! Thank you!