Cell Syntax
- Numbers must begin with a digit.
- Text cells begin with anything except "=".
- Function cells begin with "=".
- Cell names begin with a lowercase letter, a1 etc.
- Function names begin with a capital letter, Abs etc.
Mathematical Functions
- Abs(x) returns the absolute value of x.
- Acos(x) returns the arccosine of x.
- Asin(x) returns the arcsine of x.
- Atan(x) returns the arctangent of x.
- Ceil(x) returns the smallest integer greater than or equal to x.
- Cos(x) returns the cosine of x.
- Exp(x) returns the exponential of x.
- Floor(x) returns the largest integer less than of equal to x.
- Log(x) returns the natural logarithm of x.
- Max(x, y) returns the larger of x or y.
- Min(x, y) returns the smaller or x or y.
- Pow(x, y) returns x raised to the power y.
- Random() returns a random number.
- Round(x) rounds x to the nearest integer.
- Sin(x) returns the sine of x.
- Sqrt(x) returns the square root of x.
- Tan(x) returns the tangent of x.
Comparision Functions
- Lt(x, y) returns 1 if x
- Le(x, y) returns 1 if x <= y, else 0. Gt(x, y) returns 1 if x > y, else 0. Ge(x, y) returns 1 if x >= y, else 0. Eq(x, y) returns 1 if x = y, else 0. Ne(x, y) returns 1 if x != y, else 0.
Boolean Functions
- And(x, y) returns 1 if x and y are nonzero, else 0.
- Or(x, y) returns 1 if x or y is nonzero, else 0.
- Not(x) returns 1 if x is zero, else 0.
Conditional functions
- If(x, y) returns y if x is non zero, else 0.
- If(x, y, z) returns y if x is non zero, else z.
Intrepid Technology Inc. has kindly granted Permission to The Artisan to use their Java Spreadsheet Applet on our site. We thank them for their Internet community spirit. The author of the spreadsheet is Dr. Robert Lum. Dr. Lum may be reached at: robertl@intrepid.com .
