Learn Programming and technology with ease @ developerpublish.com

HomeMicrosoft OfficeExcelROMAN Function in Excel

# ROMAN Function in Excel

In this post, you will learn about a simple Excel function called ROMAN Function and how to use it in your excel spreadsheets.

## What are the Arabic Numbers and the Roman Numbers?

• The Arabic numbers are the ten digits 0,1,2,3,4,5,6,7,8 and 9
• Together they form the presentÂ Decimal system
• Roman numbers are certain symbols used in the system of numerical notation.
• They are based on the ancient Roman system

## Syntax

`=ROMAN(number, form)`

The syntax has two arguments

• number â€“ This holds the number to be converted
• form â€“ This holds what type of Roman number you want (optional)

## How to use ROMAN Function in Excel?

• The function returns the respective Roman numerals for the given numbers.
• This ROMAN Function is the opposite of the ARABIC Function.
• The form argument specifies what type of Roman number that you want, that is classic, simplified, etc.
• To start, enter the numbers in the excel sheet, and in a new cell enter the syntax and highlight the cell to include it in the syntax.
• Press enter to display the answer and use the fill handle to apply the function to the rest of the data.

The function does not accept negative numbers and returns #NUM! as an error.

When non â€“ numeric values are used in the syntax it returns the #VALUE! error.

Share:

### You May Also Like

#### SKEW.P Function in Excel

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...

#### SKEW Function in Excel

In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...

#### RANK.EQ Function in Excel

In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
• Excel
• November 23, 2021