Hey all, Friday Formula Time Again….today let’s look at how to easily keep track of what your formulas actually mean.
When you are creating a formula or many formulas as is usually the case in a spreadsheet solution sometimes is would be very useful to be able to have an explanation to remind you, or to convey your logic or instructions to a user of what your formula is doing.
Excel actually has a function we can use to do this. The (N) function. To use it just use the + sign after your formula and what ever you want as your formula in quotes.
See my example below-
The user just needs to click into the cell to see the comment. So- what is the N function anyway?
N actually will convert stuff to numbers and zeros, but we can use it with text (which represents anything else to zeros in the explanation of the function in the above screenshot). So, the N is the “comment between the double quotes” as when you add zero to a number, the result is zero- cool.
Do you use this function at all. Let me know what you think.
Formula Friday- How To Pick A Winner Using Excel
Formula Friday- Find The k-th Largest Value In Your Excel Data Set Using The LARGE Function
Formula Friday- Use the LEN Formula To Highlight Issues With My Data Import