Hey there! I'm busy updating my books for Excel 2013. So not a lot of time to post.
Here's a quick tip you can use to add comments directly into your formulas.
.
Got a complex formula that you know you'll forget in 6 months? Add some comments to them by using the N() function.
.
The N() function allows you add documentation directly inside your cells. To use it, simply add a + sign to the end of your formula, and then pass some text in quotes to the N function. For example:
=Sum(A1) + N("Yes … I am summing one cell.")
.
Here is a quasi-real example:
.
Once you use the N function, you can simply look in the formula bar to figure out what the hell you were thinking when you wrote that formula 2 years ago.
Interesting tip, but why this instead of commenting the cell? Not criticizing, just curious.
~tanya
Tanya: That's a fair question. I sometimes do this when I want to add notes just for myself – not necessarily my audience. A comment will show that ugly triangle in the corner of the cell, which no one will care about.
Also, with this, you can essentially have two comments! One in the cell, and one in the traditional comments box.
This works only with formulas that return values. Am I right?
Cool anyway!
Both N() and T() have other more important uses, they can be used to produce a usable array from Offset(Ref,{Array},0) that can be processed by other worksheet functions
Ex Assuming we have Text data from A1:A10
=Counta(Offset(A1,{1,5,6},0)) Array entered will give 1
However
=Counta(T(Offset(A1,{1,5,6},0))) will give 3
Like wise N() for numbers
There are so many ray ban rb3025 where to get good but ray ban wayfarer sunglasses?You are so lucky that I just find the ray ban aviator sunglasses that can fit your mind.You can go to choose one to see if I cheat you.
Nice call Sam! I've always disregarded N and T as legacy and useless.