Take our Excel course! https://www.careerprinciples.com/courses/excel-for-business-finance
DOWNLOAD the free Excel file for this video: https://careerprinciples.myflodesk.com/sjv7h1di90
The IF function is probably the most important function you can learn in Excel. In this video I have collected 5 usage examples, from easiest to most difficult. First, we'll start with a simple IF statement with greater than as a logical test. Next, we will learn the IFS formula. Third, we will learn how to combine formulas such as IF AND. Fourth, we will look at other formulas that use IF such as SUMIFS or COUNTIFS. Finally, we'll look at using the wildcard with the SUMIFS formula. After this IF function tutorial in Excel, you should be able to apply the IF formula to any working environment.
LEARN:
Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
The complete finance and valuation course: https://www.careerprinciples.com/courses/finance-valuation-course
Excel for Business and Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
All our courses: https://www.careerprinciples.com/courses
SOCIAL:
Instagram – https://www.instagram.com/careerprinciples/?hlen
TikTok – https://www.tiktok.com/@career_principles
LinkedIn – https://www.linkedin.com/company/careerprinciples/
Chapters:
0:00 - IF Simple Formula
2:12 – IFS formula
3:58 – Combining IF AND formulas
6:11 – SUMIFS Formula
8:27 – Generic formula functionality
Disclaimer: I may receive a commission from some of the links provided at no additional cost to you.
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments