Microsoft® Excel® 2010 Formulas & Functions Inside Out

How Engineering Functions Are Organized

Engineering functions can be divided into four groups (see Table 17-1, Table 17-2, Table 17-3, and Table 17-4):

• Conversion functions

• Functions for complex numbers

• Functions for higher mathematics

• Saltus functions

Unlike the alphabetical arrangement in the Excel ribbon list, this chapter looks at the functions according to the preceding grouping.

Conversion Functions

The conversion functions help you convert numbers from one number system into another; for example, from the hexadecimal system common in electronic data processing to the more familiar decimal system.

With CONVERT(), you can convert one physical measurement into another. This is especially helpful when you are dealing with US measurements. For example, ...