MSOfficeExcel 2007 Tutorial Engineering Functions 72 codes

  1. Home
  2. MSOfficeExcel 2007 Tutorial
  3. Engineering Functions
1 =BIN2DEC(1111111111) converts binary 1111111111 to decimal (-1)
2 =BIN2HEX(11111011, 4) converts binary 11111011 to hexadecimal with 4 characters
3 =BIN2HEX(1111111111) converts binary 1111111111 to hexadecimal
4 =BIN2OCT(1001, 3) converts binary 1001 to octal with 3 characters
5 =BIN2OCT(1111111111) converts binary 1111111111 to octal
6 =COMPLEX(0,1) returns Complex number with 0 and 1 as the real and imaginary coefficients
7 =COMPLEX(1,0) return Complex number with 1 and 0 as the real and imaginary coefficients
8 =COMPLEX(3,4) returns Complex number with 3 and 4 as the real and imaginary coefficients
9 =CONVERT(1 0, lbm, kg) converts 1 pound mass to kilograms
10 =CONVERT(2 5, ft, sec) returns an error(#NA), since data types are not the same type
11 =CONVERT(68, F, C) converts 68 degrees Fahrenheit to Celsius
12 =CONVERT(CONVERT(100,ft,m),ft,m) converts 100 square feet into square meters
13 =DEC2BIN(9, 4) converts decimal 9 to binary with 4 characters
14 =DEC2HEX(100, 4) converts decimal 100 to hexadecimal with 4 characters
15 =DEC2OCT(58, 3) converts decimal 58 to octal
16 =ERF(1)
17 =HEX2BIN(B7) converts hexadecimal B7 to binary
18 =HEX2BIN(FFFFFFFFFF) converts hexadecimal FFFFFFFFFF to binary
19 =HEX2DEC(3DA4A8B9) converts hexadecimal 3DA4A8B9 to decimal
20 =HEX2DEC(FFFFFFFF5B) converts hexadecimal FFFFFFFF5B to decimal (-165)
21 =HEX2OCT(4B4E) converts hexadecimal 4B4E to octal
22 =HEX2OCT(FFFFFFEE00) converts hexadecimal FFFFFFEE00 to octal
23 =IMAGINARY(0-j) get the Imaginary coefficient of the complex number 0-j
24 =IMAGINARY(4) returns the Imaginary coefficient of 4
25 =IMPRODUCT(1+2i,30) return Product of a complex number and 30
26 =OCT2BIN(7777777001) converts octal 7777777001 to binary
27 =OCT2DEC(7777777534) converts octal 7777777534 to decimal
28 =OCT2HEX(7777777534) converts octal number 7777777534 to hexadecimal
29 BESSELI(Value_to_evaluate,Order_of_Bessel_function) returns the modified Bessel function In(x)
30 BESSELJ(Value_to_evaluate,Order_of_Bessel_function) returns the Bessel function Jn(x)
31 BESSELK(Value_to_evaluate,Order_of_function) returns the modified Bessel function Kn(x)
32 BESSELY(Value_to_evaluate,Order_of_BESSELY_function) returns the Bessel function Yn(x)
33 BIN2DEC(Number) converts a binary number to decimal
34 BIN2HEX(number, number_of_characters_to_use) converts a binary number to hexadecimal
35 BIN2OCT(number, Number_of_characters_to_use) converts a binary number to octal
36 CONVERT accepts the following text values for Distance
37 CONVERT accepts the following text values for Energy
38 CONVERT accepts the following text values for Force
39 CONVERT accepts the following text values for Liquid
40 CONVERT accepts the following text values for Magnetism
41 CONVERT accepts the following text values for Power
42 CONVERT accepts the following text values for Pressure
43 CONVERT accepts the following text values for Temperature
44 CONVERT accepts the following text values for Time
45 CONVERT accepts the following text values for Weight and mass
46 DEC2BIN(number, Number_of_characters_to_use) converts a decimal number to binary
47 DEC2HEX(number, Number_of_characters_to_use) converts a decimal number to hexadecimal
48 DEC2OCT(number, number_of characters_to_use) converts a decimal number to octal
49 ERF(Lower_bound, Upper_bound) returns the error function integrated between Lower_bound and Upper_bound
50 GESTEP(number,step) returns 1 if number = step; returns 0 (zero) otherwise
51 HEX2BIN(number, Number_of_characters_to_use) converts a hexadecimal number to binary
52 HEX2DEC converts a hexadecimal number to decimal
53 HEX2OCT(number, Number_of_characters_to_use) converts a hexadecimal number to octal
54 IMABS returns the absolute value (modulus) of a complex number
55 IMAGINARY returns the imaginary coefficient of a complex number
56 IMARGUMENT returns the argument theta, an angle expressed in radians
57 IMCONJUGATE returns the complex conjugate of a complex number
58 IMCOS returns the cosine of a complex number
59 IMEXP returns the exponential of a complex number
60 IMLN returns the natural logarithm of a complex number
61 IMLOG10 returns the base-10 logarithm of a complex number
62 IMLOG2 returns the base-2 logarithm of a complex number
63 IMPOWER(complex_number, power) returns a complex number raised to an integer power
64 IMPRODUCT returns the product of complex numbers
65 IMREAL returns the real coefficient of a complex number
66 IMSIN returns the sine of a complex number
67 IMSQRT returns the square root of a complex number
68 IMSUB returns the difference between two complex numbers
69 IMSUM returns the sum of complex numbers
70 OCT2BIN(number, number_of_characters_to_use) converts an octal number to binary
71 OCT2DEC converts an octal number to decimal
72 OCT2HEX(number, Number_of_characters_to_use) converts an octal number to hexadecimal