There are a couple of basic behaviors to keep in mind when you use the Formula Editor.
- The blue rectangle surrounds the focus for the next action. Use the mouse pointer or arrow keys to ensure that only the part of the current formula is surrounded by the blue rectangle for the next action.
- The act of selecting a data column enters it into the current empty rectangle. Double-clicking a data column replaces what is in the current rectangle.
- The act of selecting a function from the left-most list or clicking a button along the top is to use what is in the rectangle as an argument.
I assume that A, B, C, I, and R are data column names. To make your formula, follow these steps:
- Select A.
- Click Multiply button.
- Select B.
- Click Multiply button.
- Press 1 and Enter.
- Click Subtract button.
- Select I.
- Click Multiply button.
- Select I.
- Click Multiply button.
- Select R.
- Select everything by clicking inside of the outer most rectangle. The rectangle should include everything so far.
- Click Subtract button.
- Select I.
- Click Multiply button.
- Select I.
- Click Multiply button.
- Select R.
- Click Multiply button.
- Select C.
The result is:
Another way is to copy the expression :A * :B * (1- :I * :I * :R) - :I * :I * :R * :C after inserting the colon (":") in front of the column names, double-click the initial empty blue rectangle in the Formula Editor, paste the expression, and press Enter.