Microsoft Office Tutorials and References

In Depth Information

**APPENDIX 1 - ALPHABETICAL FUNCTION REFERENCE**

RIGHTB(text,num_bytes) [Category: Text]

RIGHTB returns the last character or characters in a text string, based on

the number of bytes you specify. This function is for use with double-byte

characters.

ROMAN(number,form) [Category: Math]

Converts an arabic numeral to roman, as text. Guru Tip: Great for presenting

bad ﬁ nancial news. Convert your ﬁ nancial statements to Roman numerals

using ROMAN. If you need to create an outline using Roman numerals, use

=ROMAN(ROW(A1)) and copy down.

ROUND(number,num_digits) [Category: Math]

Rounds a number to a speciﬁ ed number of digits. Guru Tip: =ROUND(A1,2)

will round to two decimal places. =ROUND(A2,-3) will round to the nearest

thousand!

ROUNDDOWN(number,num_digits) [Category: Math]

Rounds a number down, toward zero.

ROUNDUP(number,num_digits) [Category: Math]

Rounds a number up, away from 0 (zero).

ROW(reference) [Category: Lookup & Reference]

Returns the row number of a reference. Guru Tip: =ROW(A1) is a clever way of

writing the number 1, because as this formula is copied down a column, it will

automatically point to ROW(A2) for 2, ROW(A3) for 3, and so on. In the image

below, both IPMT and PPMT need payment numbers as the second argument.

Rather than adding a new column with the numbers 1, 2, 3, …, 180, the formula

uses ROW(A1) as the second argument in row 8. As this gets copied down, the

second argument will generate the numbers 1 through 180. See Page 11