Casio FX-CG10, Руководство пользователя

Страница: 385 / 608

9-24
The following is the basic syntax for inputting values for V1, V2, and Value.
• Move the highlighting to the line whose setting you want to change, input a value or
calculation formula, and then press
w
. If you input a calculation formula, the final value will
be the calculation result.
• If
3
(C= ) or
4
(C
≠
) is selected for “Expre”, you can specify
2
(ERROR) or
3
(BLANK) for “Value”.
-
2
(ERROR) ... Decision depends on whether or not “ERROR” is displayed in the cell
whose settings are being configured.
-
3
(BLANK) ... Decision depends on whether or not the cell whose settings are being
configured is blank.
u Configuring Settings for Expression Type Conditions
The following condition settings can be configured when “Expression” is selected as the
condition type in step 4 under “To configure conditional formatting settings” (page 9-22).
Expre (Expression)
Use this line to directly input the conditional expression to be used for true/false judgment.
Input rules are virtually identical to those that apply when inputting an expression that starts
with an equal sign (=) into a spreadsheet cell, except for the following points.
• Do not include an equal sign (=) at the beginning of the expression.
• The function menu is identical to the one displayed during cell editing, except for the
2
(TYPE) item. For details about using other menu items besides
2
, see the following.
- “Inputting a Cell Reference Name” (page 9-11)
- “Relative and Absolute Cell Reference Names” (page 9-12)
- “Using Special Spreadsheet Mode Commands” (page 9-19)
• Pressing
2
(TYPE) displays the submenu shown below.
-
1
($) ... Inputs the dollar sign ($) used for specifying an absolute cell reference in a
conditional expression. See “Relative and Absolute Cell Reference Names” (page 9-12).