Easy Excel - Conditional Logic - The IF function (25)
Welcome to the 25th Easy Excel tutorial. Today we cover the long awaited 'if' statement (also known as the IF function) in Excel. Many years ago I went over how the if statement works in C++, the logic in excel is very similar, the syntax is a little bit different.
In Excel, the if statement is defined as a function and returns one value if true and another if false. The previous three tutorials covered the AND, OR, and NOT functions which only returns a boolean, a true or false (or 0 or 1). But if statement lets you take the boolean result and output whatever you like, it removes all logic limitations the other three functions apply.
If statement can be nested. In programming terms, these are the "else if" statements. In front of you, I have a visual representation of what's happening in excel. If condition 1 is true, do something, else if condition 2 is true, do something else, and so on, until you hit the last "else" statement which is considered the default if everything else fails.
Remember to visit my site http://www.EasyProgramming.net to view my other programming tutorials! If you have any suggestions for future videos, feel free to comment and let me know.
I hope you enjoy the video and if you have any requests feel free to let me know. Thanks for watching and remember to subscribe!
#EasyExcel #ExcelTutorial #IFFunction
-----------
Subscribe on YouTube: / nazmusnasir
Support me on Patreon: / nazmus
Follow me on Twitter: / nazmusn
Like me on Facebook: / easyprogrammingnet
Follow me on Google+: https://plus.google.com/+NazmusNasir
Check out my Github: https://github.com/naztronaut