IF Function Excel Tutorial - Test Whether A Condition Holds Using Simple and Nested IF
The IF function is one of the most popular functions in Excel and works by testing whether a condition holds, returning one value if it does and another value if it does not. We start by reviewing the Simple IF function, we then explore the Nested IF which is where one IF function is inside of another. Finally, we discuss the use of the IF function in conjunction with the AND and OR functions.
Subscribe for weekly Excel tutorials, techniques and examples:
/ @theexcelhub
Please share this video with others that may find it useful:
• IF Function Excel Tutorial - Test Whe...
Please comment below if you have any feedback or any suggestions for videos you would like us to upload next!
🌍 The Excel Hub website: https://theexcelhub.com/
📸 Instagram: / theexcelhub
ABOUT US:
The Excel Hub seeks to enhance your Excel and VBA knowledge by providing value-adding tutorials, techniques and examples in order to help you take your spreadsheet and data analysis skills to the next level.
For any enquiries, please contact:
[email protected]
Overview: (0:00)
Simple IF: (0:33)
IF To Compare Cells: (1:10)
Nested IF: (1:48)
IF With AND Function: (2:48)
IF With OR Function: (3:31)
Concluding Remarks: (4:21)