How do you comment inside a formula? - Excel Tips and Tricks - video Dailymotion

RabiGurungXybernetics

Learn how do you write comment inside the formula? Otherwise also ask as how do you write notes in a formula in Excel? Or how do you comment in Excel using if function? And how do you insert a remark in Excel?   Write Comment Inside Formula  =SUMPRODUCT(C4:F4,$C$1:$F$1)+N("This is a result of student from 2023")   How do you comment inside a formula?,How do you write notes in a formula in Excel?,How do you comment in Excel using if function?,How do you insert a remark in Excel?,   Check out my complete suite of Microsoft Excel Tips and Tricks.  https://www.youtube.com/@RabiGurungXybernetics/shorts  https://www.tiktok.com/@xybernetics247  https://www.instagram.com/rabi.gurung247/  https://www.pinterest.ca/RabiGurungXybernetics/excel-tips-and-tricks/  https://twitter.com/XyberneticsInc/media  https://www.reddit.com/r/Excel247/  https://www.facebook.com/XyberneticsInc/reels/   #microsoft #excel #tips #tipsandtricks #microsoftexcel #accounting #fyp #fypシ #exceltips #exceltricks

Transcript

00:00If you want to explain what the formula does, you can document the formula within the formula itself

00:05using the n function. Let me explain. Let's say for example, you have this complicated formula

00:10and you want to explain what this does. Basically, you're going to say plus n function,

00:15open parenthesis, double code. I'm going to say this is a result for students of 2023.

00:25Double code, close parenthesis, and hit enter. So what's happening here is that n function,

00:32and on the argument, if it's a string, it will return a value of zero. Let me show you what it

00:36does. I'm going to hit enter and if I copy that formula in here, equal that, you can see it's zero.

00:43And over here, sum product plus zero is the sum product itself.

How do you comment inside a formula? - Excel Tips and Tricks

Category

Transcript

Be the first to comment

Recommended