ROMAN Function (Functions in Excel)

Number	Roman
1	I	=ROMAN(C4)
2	II	=ROMAN(C5)
3	III	=ROMAN(C6)
5	V	=ROMAN(C7)
10	X	=ROMAN(C8)
1998	MCMXCVIII	=ROMAN(C9)
1998	MCMXCVIII	=ROMAN(C10,0)
1998	MLMVLIII	=ROMAN(C11,1)
1998	MXMVIII	=ROMAN(C12,2)
1998	MVMIII	=ROMAN(C13,3)
1998	MVMIII	=ROMAN(C14,4)
1998	MCMXCVIII	=ROMAN(C15,TRUE)
1998	MVMIII	=ROMAN(C16,FALSE)

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.

Related Posts by Categories

Excel Notes

• How to create a template in excel 2007?
• Tips for Setting Up a Table in Excel
• Table Terms in Excel
• Sorting Data in Excel (Sort Button and Sort Dialog Box)
• Separating Text in Excel (Separating the Data)
• Separating Text in Excel (Considerations)
• Hiding Columns, Rows, and Cells in Excel (Hiding Cell Contents)
• Hiding Columns, Rows, and Cells in Excel (Redisplaying Rows)
• Hiding Columns, Rows, and Cells in Excel (Hiding Rows)
• Hiding Columns, Rows, and Cells in Excel (Redisplaying Columns)
• Hiding Columns, Rows, and Cells in Excel (Hiding Columns)
• Find and Replace Features in Excel (Using the Replace Feature)
• Find and Replace Features in Excel (Using the Find Feature)
• Paste Special Feature in Excel (Paste Special Options)
• Paste Special Feature in Excel (Using the Paste Special Dialog Box)
• Using the Fill Command in Excel (Filling Cells, Filling Cells: Ribbon Option, Filling Cells: Mouse Option, Working with Custom Fills, Creating a Custom Fill, Importing Custom Fills, Using a Custom Fill)
• Working with Comments in Excel (Adding Comments, Adding Comments: Ribbon Option, Adding Comments: Mouse Option , Editing Comments, Editing Comments: Ribbon Option, Editing Comments: Mouse Option, Displaying/Hiding Comments, Displaying/Hiding Comments: Single Cell , Displaying/Hiding Comments: Ribbon Option, Displaying/Hiding Comments: All Cells , Moving Comments , Deleting Comments, Removing Comments from a Single Cell: Mouse Option, Removing Comments from a Single Cell: Ribbon Option, Removing Comments from All Cells, Printing Comments)
• Importing an External Data File in Excel
• Working with Rows and Columns in Excel (Adjusting Row Height and Column Width, Adjusting Row Height: Ribbon Option, Adjusting Row Height: Mouse Option, Adjusting Column Width: Ribbon Option, Adjusting Column Width: Mouse Option, Using AutoFit to Adjust Rows and Columns, Using AutoFit to Adjust Row Height: Ribbon Option, Using AutoFit to Adjust Column Width: Mouse Option, Using AutoFit to Adjust Column Width: Ribbon Option, Adding and Removing Rows and Columns, Adding Rows, Adding Columns, Deleting Rows, Deleting Columns)
• Calculating Subtotals in Excel (Adding Subtotals , Adjusting Views with Subtotals , To expand the view one level:, To collapse the view one level: , Removing Subtotals , Re-sorting the Data )
• Calculating with Functions in Excel (Parts of a Function , Inserting Functions, Inserting Functions: Dialog Box Option, Inserting Functions: Ribbon Option, About the Function Arguments Dialog Box, To access the Function Arguments dialog box:, Inserting Functions with the Point and Click Method, Adding Cells Together, Adding a Range of Cells with the SUM Function)
• Editing Cell Contents in Excel (Moving Information, Drag and Drop vs. Cut and Paste, Moving Information: Drag and Drop , To Undo Drag and Drop:, Moving Information: Cut and Paste , Copying Formulas, Copy and Paste )
• Working with Conditional Formatting in Excel (Applying Preformatted Rules , Applying Cell Highlighting , Applying Top, Bottom, and Average Rules , Applying Data Bars, Color Scales, and Icon Sets , Creating a Customized Rule , Editing Rules , Prioritizing Rules , Deleting Rules )
• Formatting Numbers in Excel (Formatting Numbers: Toolbar Option , Formatting Numbers: Ribbon Option , Formatting Numbers: Dialog Box Option , Clearing Number Formatting )
• Formatting Cells in Excel (Applying Cell Styles , Formatting Borders , Changing Borders, Changing Border Color , Changing Border Style , Deleting Borders , Using Conditional Formatting , Merging Cells , Creating a Cell Merge , Customizing a Cell Merge , Removing a Cell Merge , Wrapping Text, Copying Cell Formatting, Clearing Cell Formatting )

Functions in Excel

• YEARFRAC Function (Functions in Excel)
• YEAR Function (Functions in Excel)
• WORKDAY Function (Functions in Excel)
• WEEKDAY Function (Functions in Excel)
• VLOOKUP Function (Functions in Excel)
• VARP Function (Functions in Excel)
• VAR Function (Functions in Excel)
• VALUE Function (Functions in Excel)
• UPPER Function (Functions in Excel)
• TRUNC Function (Functions in Excel)
• TRIM Function (Functions in Excel)
• TREND Function (Functions in Excel) WHAT IS CONST b ?
• TRANSPOSE Function (Functions in Excel)
• TODAY Function (Functions in Excel)
• TIMEVALUE Function (Functions in Excel)
• TIME Function (Functions in Excel)
• TEXT Function (Functions in Excel)
• T Function (Functions in Excel)
• SYD Function (Functions in Excel)
• SUMPRODUCT Function (Functions in Excel)
• SUMIF Function (Functions in Excel)
• SUM and the =OFFSET Function (Functions in Excel)
• SUM (Running Total) Function (Functions in Excel)
• SUM Function (Functions in Excel)
• SUBSTITUTE Function (Functions in Excel)