Engineering functions

Number-base conversion, bit operations and engineering units. This page lists all 30 of them; each links to a full lesson with an example you can copy and a practice file.

← All function families

BASEBASE converts to any base from 2 to 36 and handles much bigger numbers than DEC2BIN.BESSELIBESSELI returns the modified Bessel function In(x), used in heat transfer, signal processing and vibration problems.BESSELJBESSELJ returns the Bessel function of the first kind, Jn(x): vibrating drums, FM radio spectra and wave problems.BESSELKBESSELK returns the modified Bessel function of the second kind, Kn(x).BESSELYBESSELY returns the Bessel function of the second kind (Weber/Neumann), Yn(x).BIN2DECBIN2DEC reads binary text (up to 10 digits) and returns the number.BIN2HEXBIN2HEX converts a binary number to hexadecimal. Used for device codes, permission bits, memory addresses and number-system lessons.BIN2OCTBIN2OCT converts a binary number to octal. Used for device codes, permission bits, memory addresses and number-system lessons.BITANDBITAND compares numbers bit by bit. Useful for decoding status flags stored as one number.BITLSHIFTBITLSHIFT shifts bits left, multiplying by powers of two.BITORBITOR combines flag numbers: a bit is on if it is on in either input.BITRSHIFTBITRSHIFT shifts a number's bits right, the same as integer division by a power of 2. Used to…BITXORBITXOR flips bits — on where exactly one input has them on.CONVERTCONVERT changes units: km to miles, °C to °F, kg to pounds, hours to minutes. Unit codes are…DEC2BINDEC2BIN converts a number to binary text. Good for teaching, flags and subnet masks, but it only handles…DEC2HEXDEC2HEX converts numbers to hex — the notation behind web colours and memory addresses.DEC2OCTDEC2OCT converts a decimal number to octal. Used for device codes, permission bits, memory addresses and number-system lessons.DECIMALDECIMAL reverses BASE.DELTADELTA returns 1 if two numbers are equal and 0 otherwise — easy to SUM for a count…ERFERF returns the error function between 0 and x (or between two limits), used in probability and diffusion.ERF.PRECISEERF.PRECISE is the 2010 version of ERF with one argument.ERFCERFC returns 1 - ERF(x): the tail beyond x.ERFC.PRECISEERFC.PRECISE is the 2010 version of ERFC.GESTEPGESTEP returns 1 if a number is greater than or equal to a step value, otherwise 0 —…HEX2BINHEX2BIN converts hex to binary text — each hex digit becomes four bits.HEX2DECHEX2DEC reads hex text — colour codes, error codes from logs — as a number.HEX2OCTHEX2OCT converts a hexadecimal number to octal. Used for device codes, permission bits, memory addresses and number-system lessons.OCT2BINOCT2BIN converts a octal number to binary. Used for device codes, permission bits, memory addresses and number-system lessons.OCT2DECOCT2DEC converts a octal number to decimal. Used for device codes, permission bits, memory addresses and number-system lessons.OCT2HEXOCT2HEX converts a octal number to hexadecimal. Used for device codes, permission bits, memory addresses and number-system lessons.