Other Functions

This category includes the ROMAN() function, which converts number values into Roman numerals. (It is not possible to calculate with this function because the result is text.) This function was categorized as a math function by Microsoft even though the authors think it belongs with the text and data functions (see Chapter 8).

Note

Some mathematical and trigonometry functions are not readily available in the standard installation of Microsoft Office Excel 2003 and earlier versions. To use these functions, you have to activate them in the Add-Ins dialog box (Tools/Add-Ins). You’ll find more information in the Analysis Functions section in Chapter 2.

Table 16-1. Mathematical and Trigonometry Functions

Function

Description

ABS()

Returns ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.