Use Excel Formula Completion for IF statements and commissions

In this Excel tutorial, I test Microsoft Excel Formula Completion with IF functions to see how well it handles real worksheet tasks. You will see how it responds to simple formulas first, then how it handles a commission IF statement with absolute references and a grade formula built from typed criteria. What's covered in this video: Use Formula Completion by pressing the equal sign in Excel Compare simple total, average, and percentage difference formulas Test an IF formula for commissions that requires absolute references Build a grade result from typed score rules without a lookup table Confirm where Formula Completion appears when you have a Copilot license A paid Microsoft 365 Copilot license is required for Formula Completion. Download the file I used in this video here: https://chrismenardtraining.com/post/... Check out my Copilot, Excel, Teams, and OneNote courses: https://courses.chrismenardtraining.com And make sure you subscribe to my channel! - EQUIPMENT USED -------------------------------- ○ My camera – https://amzn.to/3vdgF5E ○ Microphone - https://amzn.to/3gphDXh ○ Camera tripod – https://amzn.to/3veN6Rg ○ Studio lights - https://amzn.to/3vaxyy5 ○ Dual monitor mount stand - https://amzn.to/3vbZSjJ ○ Web camera – https://amzn.to/2Tg75Sn ○ Shock mount - https://amzn.to/3g96FGj ○ Boom Arm - https://amzn.to/3g8cNi6 - SOFTWARE USED -------------------------------- ○ Screen recording – Camtasia – https://chrismenardtraining.com/camtasia ○ Screenshots – Snagit – https://chrismenardtraining.com/snagit ○ YouTube keyword search – TubeBuddy – https://www.tubebuddy.com/chrismenard Chapters: 00:00 Introduction 00:34 Try simple total and average formulas 01:22 Find percentage difference 02:03 Build a commission IF formula 02:55 Check incorrect results and retry 04:22 Create a grade IF formula 05:10 Test grade boundaries 06:00 Find Formula Completion in Excel DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links I provide, I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel, so I can continue to provide you with free content each week!