gl_excel:parameters

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
gl_excel:parameters [2014/03/14 14:23 UTC] – add CallRpt function parameters mwolfegl_excel:parameters [2023/07/24 14:33 UTC] (current) – external edit 127.0.0.1
Line 3: Line 3:
  
 ===== To Quote or not to Quote ===== ===== To Quote or not to Quote =====
-  * Use quotes if you are using the **actual** data in the formula: %InlineCode{=Balance("SC11","12/31/2009")}% +  * Use quotes if you are using the **actual** data in the formula: **=Balance("SC11","12/31/2009")** 
-  * Don’t use quotes if you are **referring** to the cell that holds the data:   %InlineCode{=Balance(A1,B1)}% +  * Don’t use quotes if you are **referring** to the cell that holds the data:   **=Balance(A1,B1)** 
-    * Cell A1 would then contain %InlineCode{SC11}% **not** %InlineCode{"SC11"}% +    * Cell A1 would then contain **SC11** **not** **"SC11"** 
-    * Cell B1 would then contain %InlineCode{12/31/2009}% **not** %InlineCode{"12/31/2009"}%+    * Cell B1 would then contain **12/31/2009** **not** **"12/31/2009"**
 Please note that all examples given on this page show quoted data, as would be used if the values were directly entered into the formula.  However, it is generally better practice to enter the data in cells of their own and refer to those cells from within the formulas. Please note that all examples given on this page show quoted data, as would be used if the values were directly entered into the formula.  However, it is generally better practice to enter the data in cells of their own and refer to those cells from within the formulas.
  
  • gl_excel/parameters.1394807012.txt.gz
  • Last modified: 2014/03/14 14:23 UTC
  • by mwolfe