Page History
...
The operator '!=' compares two values and returns the boolean value TRUE if the left value is not equal to the right value and FALSE otherwise.
Syntax
Code Block |
---|
value1 != value2 |
- value1 - Number, date or attribute of some type of number or date.
- value2 - Number, date or attribute of some type of number or date.
Return type
- boolean
Examples
- 1 != 2 returns TRUE
- 1.0 != 1.0 returns FALSE
- DATE(2012,1,1) != TODAY returns TRUE
- 5 + 5 != 10 returns FALSE
ANNUITY
This function is able to directly compute an annuity for you. An annuity is a terminating "stream" of fixed payments, i.e., a collection of payments to be periodically received over a specified period of time.
It is computed using this formula:
where
- J = monthly payment
- i = rate of interest
- n = number of terms
- T = loan amount
Syntax
Code Block |
---|
ANNUITY( [currency], [percentage], [integer]) |
- currency - The total amount that should be payed back.
- percentage - The percentage that should be paid on a loan (As a fraction, e.g. 5% = 0.05)
- integer - The amount of terms.
Return type
- number - The monthly payment.
Examples
- ANNUITY(1000, 0.05, 12) = 112.8254
- ANNUITY(1000, 0.05, 1) = 1050
NOT EQUAL
NOT EQUAL
The operator '!=' compares two values and returns the boolean value TRUE if the left value is not equal to the right value and FALSE otherwise.
Syntax
Code Block |
---|
value1 != value2 |
- value1 - Number, date or attribute of some type of number or date.
- value2 - Number, date or attribute of some type of number or date.
Return type
- boolean
Examples
- 1 != 2 returns TRUE
- 1.0 != 1.0 returns FALSE
- DATE(2012,1,1) != TODAY returns TRUE
- 5 + 5 != 10 returns FALSE
ANNUITY
This function is able to directly compute an annuity for you. An annuity is a terminating "stream" of fixed payments, i.e., a collection of payments to be periodically received over a specified period of time.
It is computed using this formula:
where
- J = monthly payment
- i = rate of interest
- n = number of terms
- T = loan amount
Syntax
Code Block |
---|
ANNUITY( [currency], [percentage], [integer]) |
- currency - The total amount that should be payed back.
- percentage - The percentage that should be paid on a loan (As a fraction, e.g. 5% = 0.05)
- integer - The amount of terms.
Return type
- number - The monthly payment.
Examples
- ANNUITY(1000, 0.05, 12) = 112.8254
- ANNUITY(1000, 0.05, 1) = 1050
The operator '!=' compares two values and returns the boolean value TRUE if the left value is not equal to the right value and FALSE otherwise.
Syntax
Code Block |
---|
value1 != value2 |
- value1 - Number, date or attribute of some type of number or date.
- value2 - Number, date or attribute of some type of number or date.
Return type
- boolean
Examples