ROMAN formula In EXCEL SHEET

This  Formula is simple to use,it is  Math based Excel formula which performs the following function.

• Convert a value, written in Arabic format (standard numeral system) and converts it into the  Roman Numeral system as text. 

SYNTAX OF ROMAN FORMULA

                                               =ROMAN(number, [form])

The ROMAN formula syntax has the following arguments:

• The number argument. This can be a set value, or a cell address, of the Arabic numeral that you wish to convert.

• The optional argument, form. This is a number specifying the type of roman numeral you want. The roman numeral style ranges from Classic to Simplified, becoming more concise as the value of form increases. 
• Refer to the following list. 

1. Form Type
2.  0 or omitted Classic.
3. 1,2,3 More concise
4. 4 Simplified.
5. TRUE Classic. 
6. FALSE Simplified.

HAPPY BLOGGING!!