Microsoft Office Tutorials and References
In Depth Information
Excel 2013 includes a new function — BASE — that converts a decimal number to any
number base. Note that there is not a function that works in the opposite direction. Ex-
cel does not provide a function that converts any number base to decimal. You're lim-
ited to binary, octal, and hexadecimal.
Often, you may have values that need to be classified into a group. For example, if you have ages of people, you
might want to classify them into groups such as 17 or younger, 18 to 24, 25 to 34, and so on.
The easiest way to perform this classification is with a lookup table. Figure 16-14 shows ages in column A, and
classifications in column B. Column B uses the lookup table in D2:E9. The formula in cell B2 is
This formula was copied to the cells below.