vert line

Color Constants

Color constants are used by MAC OS X to specify how the amount of red, blue, and green present in a given color. Color constants can be used in Mesa's functions to manipulate the color of cells and ranges. Here is a list of the available color constants.

BLACKCOLOR, @BLACKCOLOR

BLUECOLOR, @BLUECOLOR

CYANCOLOR, @CYANCOLOR

DKGRAYCOLOR, @DKGRAYCOLOR

GREENCOLOR, @GREENCOLOR

LTGRAYCOLOR, @LTGRAYCOLOR

MAGENTACOLOR, @MAGENTACOLOR

REDCOLOR, @REDCOLOR

WHITECOLOR, @WHITECOLOR

YELLOWCOLOR, @YELLOWCOLOR

Format Constants

Mesa uses the following format constants in its formatting functions. These formats correspond to the different cell style formats in the Cell Style Inspector. (See "Cell Style Inspector".)

GENERALFORMAT, @GENERALFORMAT: This constant is used to specify the general format.

=FORMAT(238.093, GENERALFORMAT) -> 238.093

FIXEDFORMAT, @FIXEDFORMAT: This constant is used to specify the fixed decimal format.

=FORMAT(42.692, FIXEDFORMAT) -> 42.69

SCIENTIFICFORMAT, @SCIENTIFICFORMAT: This constant is used to specify the scientific notation format.

=FORMAT(1.69, SCIENTIFICFORMAT) -> 1.89e+01

CURRENCYFORMAT, @CURRENCYFORMAT: This constant is used to specify the currency format.

=FORMAT(555.9, CURRENCYFORMAT) -> $555.90

COMMAFORMAT, @COMMAFORMAT: This constant is used to specify the comma format.

=FORMAT(238.093, COMMAFORMAT) -> 238.09

CHARTFORMAT, @CHARTFORMAT: This constant is used to specify the chart format.

=FORMAT(7, CHARTFORMAT) -> +++++++

PERCENTFORMAT, @PERCENTFORMAT: This constant is used to specify the percent format.

=FORMAT(0.09389, PERCENTFORMAT, 2) -> 9.39%

DMYFORMAT, @DMYFORMAT: This constant is used to specify the date day-month-year format.

=FORMAT(9876.54321, DMYFORMAT) -> 15-Jan-97

DAYMONFORMAT, @DAYMONFORMAT: This constant is used to specify date day-month format.

=FORMAT(9876.54321, DAYMONTHFORMAT)

-> 15-Jan

MONYEARFORMAT, @MONYEARFORMAT: This constant is used to specify date month-year format.

=FORMAT(9876.54321, MONYEARFORMAT)

-> Jan-97

HMSFORMAT, @HMSFORMAT: This constant is used to specify date hours-minutes-seconds format.

=FORMAT(9876.54321, HMSFORMAT)

-> 1:02:13 PM

HOURMINFORMAT, @HOURMINFORMAT: This constant is used to specify date hours-minutes format.

=FORMAT(9876.54321, HOURMINFORMAT)

-> 1:02 PM

DINTL1FORMAT, @DINTL1FORMAT: This constant is used to specify the numeric date month-day-year format.

=FORMAT(9876.54321, DINTL1FORMAT)

-> 01/15/97

DINTL2FORMAT, @DINTL2FORMAT: This constant is used to specify the numeric date month-day format.

=FORMAT(9876.54321, DINT2FORMAT) -> 01/15

TINTL1FORMAT, @TINTL1FORMAT: This constant is used to specify twenty four hour time format with seconds.

=FORMAT(9876.54321, TINTL1FORMAT)

-> 13:02:13

TINTL2FORMAT, @TINTL2FORMAT: This constant is used to specify twenty four hour time format without seconds.

=FORMAT(9876.54321, TINTL2FORMAT) -> 13:02

Math Constants

Mesa uses the following mathematical constants in its functions.

PI, @PI: The area of a circle of radius one, approximately 3.14159.

RANDOM, RAND, @RAND: This function returns a random number between zero and one, including zero and excluding one.

Date Constants

Mesa uses the following date constants in its date functions to specify current date or time.

NOW, @NOW: Returns the current date serial number.

TODAY, @TODAY: Returns the current date serial number without the current time, so that the serial number only contains the day month and year information.

Special Constants

CURRENTNUMBER or @CURRENTNUMBER: The current numeric value of a cell. Can be used for time series functions. To reset a cell containing this constant, use Edit -> Clear Special -> Reset.

To remember the largest number entered into cell A1, use

=if(a1 > currentnumber,a1,currentnumber).

To count the number of times the worksheet was recalculated, use

currentnumber + 1

CURRENTVALUE or @CURRENTVALUE: The current value of the cell (before the recalc). This is useful for comparing old cell values with other values, such as taking the larger of the current value or the value of another cell.To reset a cell containing this constant, use Edit -> Clear Special -> Reset.

ERR or @ERR: Returns an error. All cells that refer to a cell with an error will evaluate to errors as well.

ERRORCONST: Returns an error. All cells that refer to a cell with an error will evaluate to errors as well.

FALSE(), FALSE or @FALSE: Returns a logical false value.

FILENAME or @FILENAME: Returns the filename of the current worksheet.

HOSTNAME, or @HOSTNAME: Returns the name of the machine that Mesa is running on.

NA or @NA: Returns a special error, NA. All cells that refer to a cell with an error will evaluate to errors as well. @NA is useful to designate cells that have a value that is not available or defined.

NACONST: Returns a special error, NA. All cells that refer to a cell with an error will evaluate to errors as well. NACONST is useful to designate cells that have a value that is not available or defined.

PATHNAME or @PATHNAME: Returns the path of the current worksheet.

THISCOLUMN: Returns the column number of the cell containing this constant.

THISROW: Returns the row number of the cell containing this constant.

TRUE(), TRUE or @TRUE: Returns a logical true value.

USERNAME, or @USERNAME: Returns the user's login name.

 

Also go to:

Index help

Contents help