# How to get a ROMAN number in Excel (ROMAN and ARABIC Functions)

**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**

It was really helpful and beneficial. Thank you so much for providing this course