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
- To paste the calculated value of a single formula into a cell (thus overwriting the form
- To copy/paste Formulas from a range of cells without changing the Absolute or Relative re
- Selecting Cells That Contain Formulas in Excel :To select cells containing Formulas in or
- Avoid the nightmare of pressing <F4> multiple times when coping and pasting formula
- To display the syntax of all formulas in a sheet:Press <Ctrl+‘> (the ‘ symbol is lo
- Range Name SyntaxName syntax rules:The Name string must begin with a text character, not
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