Engineering functions
All 18 functions in this category
CONVERTConverts numbers between compatible units of measurement like meters to feet, kilograms to pounds, and Celsius to Fahrenheit.DEC2BINConverts a decimal number to its binary representation, optionally padding the result with leading zeros to a specified width.DEC2HEXDEC2HEX converts decimal numbers to hexadecimal text format, useful for encoding inventory IDs or converting numeric values for data interchange.DEC2OCTConverts a decimal number to its octal (base 8) representation, with optional zero-padding for fixed-width output.BIN2DECConverts a binary number (base 2) represented as a text string to its equivalent decimal (base 10) numeric value.HEX2DECHEX2DEC converts a hexadecimal number to its decimal equivalent, essential for decoding batch codes and legacy inventory tracking systems.OCT2DECConverts an octal (base-8) number to its decimal (base-10) equivalent for database lookups and numeric conversions.BITANDBITAND returns the bitwise AND of two non-negative integers, useful for checking if both values share certain bits or permission flags.BITORReturns the bitwise OR of two numbers, combining all set bit positions from both values into a single numerical result.BITXORBITXOR compares the binary representations of two integers and returns a new integer whose bits show exactly where the inputs differ.BITLSHIFTBITLSHIFT returns the bitwise left shift of a number by the specified amount, effectively multiplying by 2 raised to the shift amount.BITRSHIFTBITRSHIFT shifts a number's bits rightward by a specified amount, returning an integer and effectively dividing by powers of 2.DELTACompares two numbers and returns 1 if they match, 0 if they differ; useful for conditional math and array-based counting.GESTEPReturns 1 if a number is greater than or equal to a step value, 0 otherwise; ideal for flagging or counting values meeting a threshold.COMPLEXCombines real and imaginary numbers into a complex number text string, essential for mathematical and engineering computation.IMREALExtracts the real coefficient of a complex number specified as a text string in the form a+bi or returned from the COMPLEX function.IMAGINARYIMAGINARY extracts the imaginary coefficient from a complex number, returning its numeric value for use in mathematical calculations and analysis.ERFERF calculates the error function value(s), returning the probability that a value from a normal distribution falls within specified limits.