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.

Classifying values

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

=VLOOKUP(A2,$D$2:$E$9,2)

This formula was copied to the cells below.