beautypg.com

5 potentiation, Potentiation, Potentiation (^) – Metrohm tiBase 1.1 User Manual

Page 46

background image

2.4 Formula editor

■■■■■■■■■■■■■■■■■■■■■■

38

■■■■■■■■

tiBase 1.1

Operand1

Operand2

Result

Example

Remark

Time

Time

Number

Time(1998;04;06) /
Time(1964;02;03) = 1.533
(for UTC
+1 or +2 for summer time)

Result: Number of days calculated
from December 1899, dependent
on the system time

Operand of different type: The operand which does not correspond to the result type is converted to the relevant
result type before the operation.

Number

Text

Text

1.2 / "Metrohm" = invalid

This operation is not allowed.

Text

Number

Text

"Metrohm" / 1.2 = invalid

This operation is not allowed.

Number

Time

Number

10'000 / Time(1999;10;7) = 274 (for
UTC+2)

Result: Number of days calculated
from December 1899, dependent
on the system time

Time

Number

Number

Time(1999;02;17) / 10'000 = 3.621
(for UTC+1)

Result: Number of days calculated
from December 1899, dependent
on the system time

Text

Time

Text

"Metrohm" / Time(1999;10;7) =
invalid

This operation is not allowed.

Time

Text

Text

Time(1999;10;7) / "Metrohm" =
invalid

This operation is not allowed.

2.4.4.2.5

Potentiation

Dialog window: Formula editor

Operators/Functions

Syntax
Operand1 ^ Operand2

The operands can be entered either directly or as a variable and can be of
the type Text, Number or Date/Time.

Examples

Operand1

Operand2

Result

Example

Remark

Operands of the same type:

Number

Number

Number

1.2 ^ 3 = 1.728

Complex results (which com-
prise +bi, i.e. a real and an
imaginary component) are dis-
played as an error.

Text

Text

Text

"Metrohm" ^ "AG" = invalid

This operation is not allowed.

Time

Time

Number

Time(1900;01;05) ^
Time(1900;01;02) = 196.371
(for UTC
+1)

Result: Number of days calcula-
ted from December 1899,
dependent on the system time

Operand of different type: The operand which does not correspond to the result type is converted to the relevant
result type before the operation.

Number

Text

Text

1.2 ^ "Metrohm" = invalid

This operation is not allowed.