Most Excel Users Don’t Know You Can Do This Inside a Formula
From MyOnlineTrainingHub · · 7 min

The player loads from YouTube only when you click. It uses YouTube's privacy-enhanced mode.
If the video does not play, the owner may have turned off embedding. Watch it on YouTube instead.
Description
Excel N function trick: hide comments inside your formulas so they explain themselves. 👩🏫 Learn more Excel functions and formulas with my course: https://bit.ly/tif26course ⬇️ Download the example file here and follow along: https://bit.ly/tifn26file
If you scroll through Excel’s function list, there’s one function that looks completely pointless.
It’s called N.
But for those in the know, N lets you hide comments inside your formulas, so they literally explain themselves.
Today, I'll show you how to add comments inside your formulas at the beginner, intermediate, and advanced levels, where it breaks, and how to fix it when it does.
LEARN MORE ===========
📰 EXCEL NEWSLETTER - join 450K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up
🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum
⏲ TIMESTAMPS ============== 0:00 A pointless-looking Excel function that is brilliant 0:20 What the N function actually does 0:50 The one N behavior we're going to exploit 1:10 Add a hidden comment using N 2:31 Where the N trick breaks and the solution 4:28 One more reason N isn't as pointless as it looks 5:04 Modern alternative to N 6:49 When you should use N and LET 7:14 10 modern functions hiding in plain sight
#Excel #ExcelFunctions #ExcelFormulas