Difference between revisions of "Documentation/How Tos/Calc: CURRENT function"
From Apache OpenOffice Wiki
< Documentation | How Tos
m |
|||
Line 22: | Line 22: | ||
− | === Further | + | === Further information: === |
: This function is best used only in simple situations. A more complex example: <tt>'''1 + 2*CURRENT()'''</tt> returns <tt>'''5'''</tt>, because although the <tt>'''1'''</tt> has been encountered as the formula is evaluated, it is ignored while the more important multiplication is performed. Thus <tt>'''CURRENT()'''</tt> in this case yields <tt>'''2'''</tt>, hence the result: <tt>'''1 + 2*2'''</tt> equals <tt>'''5'''</tt>. However the exact order of calculation in more complex cases should not be relied on. | : This function is best used only in simple situations. A more complex example: <tt>'''1 + 2*CURRENT()'''</tt> returns <tt>'''5'''</tt>, because although the <tt>'''1'''</tt> has been encountered as the formula is evaluated, it is ignored while the more important multiplication is performed. Thus <tt>'''CURRENT()'''</tt> in this case yields <tt>'''2'''</tt>, hence the result: <tt>'''1 + 2*2'''</tt> equals <tt>'''5'''</tt>. However the exact order of calculation in more complex cases should not be relied on. | ||
Revision as of 07:57, 8 December 2007
CURRENT
Returns the current (to date) result of evaluating the formula.
Syntax:
CURRENT()
- This function returns the result to date of evaluating the formula of which it is a part (in other words the result as far as that evaluation has got). Its main use is together with the STYLE function to apply selected styles to a cell depending on the cell contents.
Example:
1 + 2 + CURRENT()
- returns 6. The formula is calculated from left to right as: 1 + 2 equals 3, giving the result to date when CURRENT() is encountered; CURRENT() therefore yields 3, which is added to the original 3 to give 6.
A2 + B2 + STYLE(IF(CURRENT()>10; ”Red”; ”Default”))
- returns A2 + B2 (STYLE returns 0 here). If this sum is greater than 10, the style Red is applied to the cell. See the STYLE function for more explanation.
"choo" & CURRENT()
- returns choochoo.
Further information:
- This function is best used only in simple situations. A more complex example: 1 + 2*CURRENT() returns 5, because although the 1 has been encountered as the formula is evaluated, it is ignored while the more important multiplication is performed. Thus CURRENT() in this case yields 2, hence the result: 1 + 2*2 equals 5. However the exact order of calculation in more complex cases should not be relied on.