Channel | Publish Date | Thumbnail & View Count | Actions |
---|---|---|---|
| 2023-10-08 17:45:02 | ![]() 643,078 Views |
Take our Excel course! https://www.careerprinciples.com/courses/excel-for-business-finance
DOWNLOAD 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. So in this video, I’ve put together 5 examples of how to use it from easy to hard. First, we’ll start with a simple IF statement with greater than as the logical test. Then, we’ll learn the IFS formula. Third, we’ll learn to combine formulas such as the IF AND. Fourth, we’ll look at other formulas that use IF such as the SUMIFS or the COUNTIFS. Finally, we’ll look at using the wildcard with the SUMIFS formula. After this IF function tutorial on Excel, you should be able to apply the IF formula to any work setting.
LEARN:
Power BI for Business Analytics: https://www.careerprinciples.com/courses/power-bi-for-business-analytics
The Complete Finance & Valuation Course: https://www.careerprinciples.com/courses/finance-valuation-course
Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
All our courses: https://www.careerprinciples.com/courses
SOCIALS:
Instagram – https://www.instagram.com/careerprinciples/?hl=en
TikTok – https://www.tiktok.com/@career_principles
LinkedIn – https://www.linkedin.com/company/careerprinciples/
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Chapters:
0:00 - IF Formula Simple
2:12 – IFS Formula
3:58 – IF AND Formulas Combination
6:11 – SUMIFS Formula
8:27 – Wildcard Formula Feature
Disclaimer: I may receive a commission on some of the links provided at no extra cost to you.
Please take the opportunity to connect and share this video with your friends and family if you find it useful.