Computers Arts And Sciences

Front 1

IF function (excel)

Back 1

=IF (condition, value-if-true, value-if-false)

Front 2

PMT function (excel)

Back 2

=PMT(rate, NPER, PV, FV, type)

(rate) interest rate per period
(NPER) number of payments until repaid
(PV) present value of the loan (amount we are borrowing)
(FV) future value of the money (for saving or investing)
(type) enter 0 or 1 to indicate when payments are due.

Front 3

Absolute Positioning (excel)

Back 3

=$A$1+$B$1

Keep a certain position that is not relative to the new cell location. This is possible by inserting a $ before the Column letter or a $ before the Row number (or both)

Front 4

Variable (JS)

Back 4

A placeholder for storing data. In JavaScript, a
declaration statement consists of the reserved word VAR and
the name (identifier) of one or more variables

Front 5

IF function (JS)

Back 5

Conditional statement.
if (condition) {
statements if condition is TRUE
}