To add a Comment to a formula:
1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and, in parentheses, type your Comment in quotation marks.
Example:
=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")
Sabtu, 01 Oktober 2011
Adding a Comment to a Formula
Topic
Learning ExcelRelated
- Relative ReferenceWhen a formula is copied, a Relative reference is used. A Relative refe
- Range Name SyntaxName syntax rules:The Name string must begin with a text character, not
- Inserting/Editing FormulasTo open the Insert Function dialog box:Select an empty cell and
- A formula can be copied and pasted into the appropriate place within another formula in t
- To copy/paste Formulas from a range of cells without changing the Absolute or Relative re
- To paste the calculated value of a single formula into a cell (thus overwriting the form
Langganan:
Posting Komentar (Atom)
Trending
Updates
Search by Label
Learning Excel
(13)
Teaching and Student
(3)
Education Software
(2)
First Learning
(1)
Kids and Toys
(1)
Teaching Media
(1)
EmoticonEmoticon