
Click Here to download the Excel File which contains the Below Examples.
Description of Functions
ROMAN Function:- This Function will help to convert Arabic Numbers(1,2,3……..) to Roman Numbers(I, II, III, IV…….).
ARABIC Function:- This Function will help to Convert Roman Numbers(I, II, III, IV…….) to Arabic Numbers(1,2,3……..).
Note:- ARABIC Numbers means 1,2,3,4,5…….
The Syntax of Functions
ROMAN Function
ROMAN(number,[form])
1st Argument(Compulsory): number
2nd Argument(optional): [form]
ARABIC Function
ARABIC(text)
1st Argument(Compulsory): text
Description of Arguments
Roman Function
- number: 1st Argument(Compulsory) select the number which we want to convert in ROMAN number style.
- [form]: 2nd Argument(Optional) here we need select options to use different methods to write the ROMAN numbers. Total of 5 methods available from 0 to 4. If 2nd argument is ignored default method 0 is used.
- If you are not sure which option to select in the 2nd argument you can ignore it.
- Please see below the example of 5 different method results.

ARABIC Function
text : 1st Argument(Compulsory) here we need to select the ROMAN number to convert to normal numbers(Arabic Numbers)
Explanation of ROMAN and ARABIC Functions with Examples

Example 1: Convert ARABIC Numbers(1,2,3,…..) to ROMAN numbers().
Formula used in Cell C9=ROMAN(B9)
Result is I

Example 2: Convert ROMAN Numbers(I, II, III……) to ARABIC numbers
Formula used in Cell C23=ARABIC(B23)
Result is 1