The ROMAN perform is a Math and Trigonometry perform, and its objective is to transform an Arabic numeral to Roman as Textual content. The error worth #VALUE is returned If the quantity is adverse or larger than 3999. The formulation for the ROMAN perform is
ROMAN (quantity, [form]).
On this tutorial, we are going to clarify how you can use the ROMAN perform. The Syntax for the ROMAN perform.
Quantity: The Arabic numeral to transform. It’s required.
Kind: The kind of Roman numeral you need. It’s non-obligatory
use ROMAN perform in Excel
Open Microsoft Excel.
Create a desk.
Within the cell the place you wish to place the end result sort =ROMAN(A2).
A2 is the cell that comprises the arabic numeral.
Press enter on the keyboard to see the end result and drag the fill deal with right down to see the opposite solutions.
Technique one is to click on the fx button on the highest left of the excel worksheet.
An Insert Perform dialog field will seem.
Contained in the dialog field within the part, Choose a Class, choose Math and Trig from the checklist field.
Within the part Choose a Perform, select the Roman perform from the checklist.
Then click on OK.
A Perform Arguments dialog field will open.
Contained in the dialog field within the Quantity part, sort cell A2 inside the field or click on cell A2, and it’ll seem within the field.
The part Kind is non-obligatory.
Then click on OK.
Technique Two is to click on the Formulation tab and click on the Math and Trig button within the Perform Library group.
Within the drop-down checklist, click on the Roman perform.
A Perform Arguments dialog field will seem.
Observe the steps in technique one for Perform Arguments.
We hope this tutorial helps you perceive how you can use the ROMAN perform in Microsoft Excel.
Learn subsequent: use the RANDBETWEEN Perform In Excel.