Learn How To Add Comments To A Formula With This Microsoft Excel Tutorial
RSS
 View all Hubs
See what's in...

Microsoft Excel: Add Comments To A Formula

Article by Mr Excel (11,376 pts )
Published on Jun 25, 2008
Problem: You spent a great deal of time perfecting a formula, as shown in Fig. 386. You would like to leave yourself notes about it.
21 views

See all Microsoft Excel tips

Strategy: There is an old Lotus 1-2-3 function that is still in Excel. This function is the N function. It turns out that N of a number is the number and N of any text is zero. Thus, you can add several N functions to a formula without changing the result, provided that they contain text.

Thus, if you have figured out some obscure formula, you can leave yourself

notes about the formula, as shown in Fig. 387.

Summary: For particularly complicated formulas, leave yourself detailed comments right in the formula.

Functions Discussed: =N()


See all Microsoft Excel tips
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     

Images

Fig. 386Fig. 387

Bright Hub - Science & Technology Articles, Buyer's Guides, How-To Tips and Software Reviews
About Bright Hub | Contact Us | Terms of Use | Privacy Policy | Copyright Policy | ©2008 Bright Hub Inc. All rights reserved. Page copy protected against web site content infringement by Copyscape