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
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
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