8,849
edits
Changes
no edit summary
In order to round an expression to two decimal places.
</pre>
==Conditional Statements==
Conditional Javascript statements can be used. For example, to return the value of cell ''[1,3]'' if the value ''other'' is chosen in cell ''[1,2]'' and otherwise return the value of cell ''[1,2]'', use:
<pre style="white-space: pre-wrap; white-space: -moz-pre-wrap; white-space: -pre-wrap; white-space: -o-pre-wrap; word-wrap: break-word;">= (([1,2]=='other') ? [1,3] : [1,2])</pre>
==See Also==