Engineering Functions¶
Base Conversion¶
| Function | Syntax | Example | Result |
|---|---|---|---|
| BIN2DEC | BIN2DEC(binary) |
=BIN2DEC("1010") |
10 |
| DEC2BIN | DEC2BIN(number, [places]) |
=DEC2BIN(10) |
1010 |
| OCT2DEC | OCT2DEC(octal) |
=OCT2DEC("17") |
15 |
| DEC2OCT | DEC2OCT(number, [places]) |
=DEC2OCT(15) |
17 |
| HEX2DEC | HEX2DEC(hex) |
=HEX2DEC("FF") |
255 |
| DEC2HEX | DEC2HEX(number, [places]) |
=DEC2HEX(255) |
FF |
Unit Conversion¶
CONVERT¶
Converts a number from one measurement unit to another.
=CONVERT(100, "cm", "in") -- converts 100 centimeters to inches.
Common unit categories: weight ("kg", "lbm"), distance ("m", "ft", "mi"), temperature ("C", "F", "K"), time ("hr", "min", "sec"), volume ("l", "gal").
Comparison¶
| Function | Syntax | Example | Result |
|---|---|---|---|
| DELTA | DELTA(number1, number2) |
=DELTA(5, 5) |
1 (equal) |
| GESTEP | GESTEP(number, [step]) |
=GESTEP(3, 2) |
1 (number >= step) |
Complex Numbers¶
| Function | Syntax | Example | Description |
|---|---|---|---|
| COMPLEX | COMPLEX(real, imaginary) |
=COMPLEX(3, 4) |
Returns "3+4i" |
| IMREAL | IMREAL(complex) |
=IMREAL("3+4i") |
3 |
| IMAGINARY | IMAGINARY(complex) |
=IMAGINARY("3+4i") |
4 |
| IMABS | IMABS(complex) |
=IMABS("3+4i") |
5 |
| IMSUM | IMSUM(complex1, ...) |
=IMSUM("1+2i", "3+4i") |
"4+6i" |