Page 395 - Excel for Scientists and Engineers: Numerical Methods

3 72 EXCEL: NUMERICAL METHODS

Fix Function
Truncates a number to an integer.
Syntax: Fix(numbe0
If number is negative, Fix returns the first negative integer greater than or equal to
number.
Example: Fix(-2.5) returns -2.
See also: Int

Font Property
Returns the font of the object. Read-only.
Syntax: object. Fon t
Example: ActiveCell.Font.Bold = True makes the characters in the active cell bold.
See also: Fontstyle

FontStyle Property
Returns or sets the font of the object. Read-write.
Syntax: object. Fon tStyle
Example: Range("A1 :El"). Font.FontStyle = "Bold"
See also: Font

For ... Next Command
Delineates a block of statements to be repeated.
Syntax: For counter = start To end Step increment
(statements)
Next counter
Step increment is optional; if not included, the default value 1 is used. lncrement
can be negative, in which case start should be greater than end.
Example: See examples of For ... Next procedures in Chapter 2.
See also: Do ... Loop, Exit, For Each ... Next, While ... Wend

For Each ... Next Command
Delineates a block of statements to be repeated.
Syntax: For Each element In group
(statements)
Next element
Group must be a collection or array. Element is the name assigned to the variable
used to step through the collection or array. Group must be a collection or array.
Example: See examples of For Each ... Next procedures in Chapter 2.
See also: Do ... Loop, Exit, For ... Next, While ... Wend

Format Function
Formats a value according to a formatting code expression.
Syntax: Form at( expression, formattext)
Expression is usually a number, although strings can also be formatted. formattext
is a built-in or custom format. Additional information can be found in Microso@