The text of the note must appear in double quotes ("") and returns a value of 0 so it does not affect the calculation. ![]() Simply enter +N("whatever note you want") at the end of the formula. You can use the N function to enter notes directly in a formula. =N(argument) Using the N function to enter notes Recommended articles: Hiding Notes in Excel (Inserting, Editing, Showing, Hiding and Deleting Comments) and How to Hide Formulas from Clients, Colleagues and Other Users Syntax The N function converts a value to a number and has been around for a long while so you can use it in older versions of Excel as well. ![]() In addition to adding comments in Excel, there is a relatively obscure function called the N function that you can use to enter notes directly within a formula. How to Insert Notes in Formulas using a Function in Excelīy Avantix Learning Team | Updated November 24, 2019Īpplies to: Microsoft® Excel® 2010, 2013, 2016, 2019 and 365 (Windows)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |