ROMAN

Returns a Roman numeral (eg XIV), as text, given a number.

Syntax:

ROMAN(number, mode)

number is a number in the range 1-3999 that is to be converted into a Roman numeral.

mode (optional, in the range 0-4) indicates the degree of simplification. The higher the value, the greater is the simplification of the Roman number.

Example:

ROMAN(999)

returns CMXCIX.

ROMAN(999, 0)

returns CMXCIX.

ROMAN(999, 1)

returns LMVLIV.

ROMAN(999, 2)

returns XMIX.

ROMAN(999, 3)

returns VMIV.

ROMAN(999, 4)

returns IM.

Application:

A great application of the ROMAN function is when you are creating a table of contents for a long document or a book, where the introductory pages (like the preface, acknowledgments, and table of contents itself) are often numbered with Roman numerals.

Here's an example using a hypothetical table of contents for a book titled "The History of Ancient Rome":

Scenario: You are creating a table of contents and want the preliminary pages to be numbered with Roman numerals.

Table: Table of Contents

	Page Number	Section Title
	A	B
1	ROMAN(1)	Title Page
2	ROMAN(2)	Copyright and Dedication
3	ROMAN(3)	Preface
4	ROMAN(4)	Acknowledgements
5	ROMAN(5)	List of Maps and Illustrations
6	1	Chapter 1: The Founding of Rome
7	23	Chapter 2: The Roman Republic
8	58	Chapter 3: The Rise of the Empire

Resulting Table:

	Page Number	Section Title
	A	B
1	I	Title Page
2	II	Copyright and Dedication
3	III	Preface
4	IV	Acknowledgements
5	V	List of Maps and Illustrations
6	1	Chapter 1: The Founding of Rome
7	23	Chapter 2: The Roman Republic
8	58	Chapter 3: The Rise of the Empire