Right (Returns the rightmost characters from a text value)

What Does It Do?

This function displays a specified number of characters from the right hand side of a piece of text.

Syntax

=RIGHT(OriginalText,NumberOfCharactersRequired)

Formatting

No special formatting is needed.

Example

The following table was used to extract the second name of a person from their full name.

The =FIND() function locates the position of the space between the first and second name.

The length of the second name is calculated by subtracting the position of the space from the overall length of the full name.

The =RIGHT() function can then extract the second name.

Roman (Converts an arabic numeral to roman, as text)

What Does It Do?

This function produces a number shown as Roman numerals in various formats.

Syntax

=ROMAN(NormalNumber,RomanNumberFormat)

The RomanNumberFormat can be any of the following.

0 is Classic. This is used if no format is specified.

1 is more Concise.

2 is even more Concise.

3 is even more Concise still.

4 is Simplified.

TRUE is Classic

FALSE is Simplified

Formatting

No special formatting is needed.

Note

There is no function to do the opposite calculation of Roman to normal.

Round (Rounds a number to a specified number of digits)

What Does It Do?

This function rounds a number to a specified amount od decimal places.

If 0 is used the number is rounded to the nearest whole number.

If a negative amount of rounding is used the figures to the left of the decimal point are rounded.

Syntax

=ROUND(NumberToRound,DecimalPlacesToUse)

Formatting

No special formatting is needed.

Rounddown (Rounds a number down, toward zero)

What Does It Do?

This function rounds a number down to a specified amount of decimal places.

If 0 is used the number is rounded down to the nearest whole number.

If a negative amount of rounding is used the figures to the left of the decimal point are rounded.

Syntax

=ROUNDDOWN(NumberToRound,DecimalPlacesToUse)

Formatting

No special formatting is needed.