


Returns a Bitwise 'Exclusive Or' of two numbers (New in Excel 2013) Returns a Bitwise 'Or' of two numbers (New in Excel 2013) Returns a Bitwise 'And' of two numbers (New in Excel 2013) Returns the complementary error function integrated between a supplied lower limit and infinity (New in Excel 2010) Returns the complementary error function integrated between a supplied lower limit and infinity Returns the error function integrated between 0 and a supplied limit (New in Excel 2010) Returns the error function integrated between two supplied limits Note that some of the functions are new to Excel 2010 or Excel 2013 and so are not available in earlier versions of Excel.Įxcel Engineering Functions Converting Between Units of MeasurementĬonverts a number from one measurement system to anotherĬalculates the modified Bessel function In(x)Ĭalculates the modified Bessel function Kn(x)Ĭalculates the modified Bessel function Yn(x)Ĭonverts a hexadecimal number to a decimal
#Civil engineering excel formulas pdf full
Selecting a function name will take you to a full description of the function with examples of use. In the tables below, the Excel Engineering functions have been grouped into categories, to help you to find the function you need. Engineers may also find the Excel Math and Trig functions useful. The Excel Engineering Functions perform the most commonly used engineering calculations, many of which relate to Bessel Functions, Complex Numbers or converting between different bases.
