How to Use Excel ROMAN Function in Office 365? – [with Examples]
Tags: excelfunctions, excelromanfunctionin
Published: 2020-08-27 11:01:11

---
title: How to Use Excel ROMAN Function in Office 365? – [with Examples]
published: true
date: 2020-08-26 12:29:18 UTC
tags: ExcelFunctions,ExcelROMANFunctionin
canonical_url: https://geekexcel.com/how-to-use-excel-roman-function-in-office-365-with-examples/
---

## Excel ROMAN Function:

![ROMAN Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/ROMAN-Function.png)<figcaption id="caption-attachment-12655">ROMAN Function</figcaption>

In this article, we are going to see the usage of **Excel ROMAN Function in Office 365** with its syntax, explanation, and examples. Let’s see them below!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)


## **ROMAN Function – Description:**

- This function **converts a number to a Roman numeral as text**.
- For example, **ROMAN(5)** returns the Roman numeral **V**.

## **Syntax:**

**=ROMAN(number, [form])**

### Argument Explanation:

**Number** – The input number that needs to be converted into the Roman numeral.

**Form** – It is optional. This is the type of numeral that you want.

### Note:

- If the number is a negative value or greater than 3999 and then it returns **#VALUE!** Error.

## **Examples:**

Let’s see some examples to know how it works.

Form: This is an optional one and it is used to specify the type of the Roman number that you want. It ranges between “ **0, 1, 2, 3, 4, TRUE, and FALSE** “. The corresponding Roman type will be printed in the output. Kindly, refer to the below image.

![Form Options](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/4-19.png)<figcaption id="caption-attachment-12652">Form Options</figcaption>

### Example 1:

- Refer to the below screenshot.
- The input numbers are given in **Column A** , and its form (a type of Roman numeral) values are given in **Column B**.
- The output Roman numerals are listed in **Column C**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/5-14.png)<figcaption id="caption-attachment-12653">Example 1</figcaption>

From the above image, you can see the different types of Roman values of the given number “ **498** ” to the corresponding **Form** options.

### Example 2:

- The following example has no form values, see them below.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-79.png)<figcaption id="caption-attachment-12650">Example 2</figcaption>

### Example 3:

- If the number is a negative value or greater than 3999 and then it returns **#VALUE!** Error.

![Example 3](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/2-64.png)<figcaption id="caption-attachment-12651">Example 3</figcaption>

## **Bottom-Line:**

In this article, you can clearly understand the usage of **Excel ROMAN Function in Office 365** with its syntax, description, and examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Read Also:

- [How to Use Excel POWER Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-power-function-in-office-365-with-examples/)
- [How to Use “Excel LOG10 Function” in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-log10-function-in-office-365-with-examples/)