Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| 2019-12-17 06:50:58 | ![]() 661,944 Views |
Learn how to use the IF function, one of the most popular functions in Microsoft Excel. The IF function allows you to make logical comparisons between a value and what you expect. 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).
Microsoft support article on using the IF Function: https://support.office.com/en-us/article/IF-function-69AED7C9-4E8A-4755-A9BC-AA8BBFF73BE2
Access the sample data that I use in this video here: https://1drv.ms/x/s!AmxrofZZlZ-whIZwdMF_j150IEu-cA?e=Z5YZYQ
Watch more Excel tutorial videos: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
– Learn the fundamentals of Excel in just 2 hours: https://kevinstratvert.thinkific.com
As full-disclosure, I work at Microsoft as a full-time employee.
Please take the opportunity to connect and share this video with your friends and family if you find it useful.