YSI BODAnalyst User Manual
Page 41
Reports
Section 8
YSI Incorporated
BOD Analyst for Windows Software
37
3.
Release the left mouse button when the pointer is over the new location for the copied cells.
To move only data:
1.
Select the cells you want to move with the mouse.
2.
Press CTRL-X (or select Edit/Cut from the menu) to cut data to the clipboard.
3.
Click on the destination cell and press CTRL-V (or select Edit/Paste) to paste data from the
clipboard.
8.1.6 USING FORMULAS
You can define formulas (math expressions) for cells. The formulas can use cell references to
calculate values depending on the contents of other cells. To enter a formula for the current cell,
simply click on the formula textbox and enter the formula.
To refer to other cells in formulas type in the column header Letter and then the row number. For
example, to refer to the cell that is in the first column (A) and the first row (1) use A1'. The
second column, second row is referred to as B2. To refer to a block of cells, use the start cell then
the colon : then the stop cell. For example, to refer to cells A1, A2, A3, and A4 enter A1:A4.
The following screen illustrates cell references.
The following table lists the operations available as math expressions.
Operator
Description
Example
+
Addition
A1 + B2
- Subtraction
A1
-
B2
^
Exponentiation
A1 ^ B2
*
Multiplication
A1 * B2
/
Division
A1 / B2
&
Logical And
A1 & B2
|
Logical Or
A1 | B2
:
Creates a range
A1: B2
8.1.7 FUNCTIONS IN FORMULAS
General Functions