{"id":57,"date":"2016-03-12T16:44:24","date_gmt":"2016-03-13T00:44:24","guid":{"rendered":"http:\/\/www.susmg.info\/alandale\/tips\/?p=57"},"modified":"2016-09-02T01:14:38","modified_gmt":"2016-09-02T01:14:38","slug":"an-alternative-way-to-add-comments-to-a-cell","status":"publish","type":"post","link":"https:\/\/www.alandaletraining.com\/software-tips\/2016\/03\/12\/an-alternative-way-to-add-comments-to-a-cell\/","title":{"rendered":"An alternative way to add comments to a cell"},"content":{"rendered":"
\n
\n

You have likely discovered Comments in Excel which are useful if you want to capture some thought about the value in a cell.\u00a0 (Right-click on the cell, Insert Comment)<\/p>\n

As an alternative to Comments, I sometimes use the N function.\u00a0 The N function lets you add comments that are displayed in Formula Bar. \u00a0So when I click on a cell and look at the Formula Bar, I see the calculation and my notes next to it.
\n\"\"
\nIf you want to use the N function, just type it as shown with ” around the text.<\/p>\n

You can use the N function anywhere in a calculation, just put a + either side of it.\u00a0 So your formula could look like this: =22*3.25\u00a0 + N(“increased quantity to 22”)\u00a0 + 5.5*6<\/p>\n

 <\/p>\n<\/div>\n<\/div>\n

\n

Any questions, please let me know<\/a>.<\/p>\n

\n