# What is an ENGINEERING formula in a spreadsheet?

Engineering formulas and functions are designed for performing engineering-related calculations. They encompass conversions, trigonometry, logarithms, statistical analysis, and other mathematical operations specific to engineering disciplines.

## ENGINEERING formula usage examples.

The BIN2HEX function is used to convert a signed binary number to signed hexadecimal format. It takes two arguments: the signed_binary_number, which is the binary number to be converted, and the optional significant_digits, which specifies the number of significant digits to include in the result. The function returns the signed hexadecimal representation of the binary number.

The BITOR function is used to perform a bitwise boolean OR operation on two numbers. It returns a number that represents the result of the operation. Each bit of the result is determined by applying the OR operation to the corresponding bits of the input numbers. If either bit is 1, the result bit will be 1; otherwise, it will be 0.

The BITXOR function is used to perform a bitwise XOR (exclusive OR) operation on two numbers. It returns the result of applying the XOR operation on the binary representations of the two values. Each bit in the result is calculated by comparing the corresponding bits in the input values. If the bits are different, the result bit is set to 1; otherwise, it is set to 0.

The COMPLEX function is used to create a complex number given real and imaginary coefficients. It takes three parameters: real_part, which represents the real coefficient of the complex number; imaginary_part, which represents the imaginary coefficient of the complex number; and suffix, which is an optional parameter used to specify the unit of the complex number. If the suffix is not provided, the complex number is assumed to be dimensionless.

The DEC2BIN function is used to convert a decimal number to its signed binary format. It takes two arguments: the decimal number to be converted and an optional argument for the number of significant digits in the binary representation. The function returns the signed binary representation of the decimal number.

The HEX2BIN function is used to convert a signed hexadecimal number to signed binary format. It takes two arguments: the signed_hexadecimal_number, which is the hexadecimal number to be converted, and the optional significant_digits, which specifies the number of significant digits to include in the binary representation. If the significant_digits argument is omitted, the function will include all significant digits in the binary representation.

The HEX2DEC function is used to convert a signed hexadecimal number to decimal format. It takes a single argument, the signed hexadecimal number, and returns the corresponding decimal value. The function ignores any non-hexadecimal characters in the input and treats the remaining characters as a hexadecimal number. If the input is a negative number, it is represented in two's complement form.

The IMCOSH function returns the hyperbolic cosine of a given complex number. It takes a single argument, 'number', which represents the complex number for which the hyperbolic cosine needs to be calculated. The function treats the 'number' as a complex number in the form 'x+yi', where 'x' and 'y' are real numbers. The result is a complex number in the form 'cosh(x+yi)', where 'cosh' is the hyperbolic cosine function.

The IMDIV function returns one complex number divided by another. It takes two arguments: the dividend and the divisor. The dividend and divisor can be either complex numbers or references to cells containing complex numbers. The function performs the division operation and returns the result as a complex number.

The IMPRODUCT function returns the result of multiplying a series of complex numbers together. It takes multiple arguments, each representing a factor to be multiplied. The function can handle both real and complex numbers. If any of the arguments are non-numeric, the function returns the #VALUE! error.

The IMSIN function returns the sine of a given complex number. It takes a single argument, 'number', which represents the complex number for which we want to calculate the sine. The function treats the real and imaginary parts of the complex number separately and applies the sine function to each part. The result is a complex number representing the sine of the input complex number.

The IMSINH function returns the hyperbolic sine of a given complex number. It takes a single argument, 'number', which represents the complex number for which the hyperbolic sine needs to be calculated. The function treats the 'number' as a complex number in the form 'x+yi', where 'x' and 'y' are real numbers. The result is a complex number in the form 'sinh(x+yi)'.

The OCT2BIN function in Excel is used to convert a signed octal number to a signed binary format. It takes the signed_octal_number as the input and optionally the significant_digits parameter to specify the number of significant digits in the binary representation. The function returns the binary representation of the octal number as a text value.