Shaqada Roomaanka^(ROMAN) waa xisaab^(Math) iyo Trigonometry , ujeeddadeeduna waa in nambarka Carabiga loo beddelo ^(Arabic)Roomaaniga ^(Roman)qoraal^(Text) ahaan . Khaladaadka qiimaha # VALUE waa la soo celinayaa Haddii nambarku uu taban yahay ama ka weyn yahay 3999. Qaaciddada shaqada Roomaanka^(ROMAN) waa ROMAN (number, [form]).

Tababarkan, waxaan ku sharixi doonaa sida loo isticmaalo shaqada ROMA^(ROMAN) . Syntax ee shaqada ROMAN .

       Nambar^{(       Number)} : Nambarka Carabiga^(Arabic) si loo beddelo. Waa loo baahan yahay.

       Foom^{(       Form)} : Nooca lambarka Roomaanka^(Roman) ee aad rabto. Waa ikhtiyaari

Sida loo isticmaalo shaqada ROMN gudaha Excel

Fur Microsoft Excel .

Samee miis.

Gudaha qolka aad rabto inaad dhigto nooca natiijada =ROMAN(A2) .

A2 waa unugga ka kooban nambarka carabiga.

Riix^(Press) geli kiiboodhka si aad u aragto natiijada oo hoos u jiid gacanta buuxinta si aad u aragto jawaabaha kale.

Habka koowaad waa inaad gujiso badhanka fx ee bidixda sare ee xaashida shaqada ee Excel.

Sanduuqa wada hadalka Gelida ayaa soo bixi doona^{(Insert Function)} .

Gudaha sanduuqa wada-hadalka ee qaybta, Dooro Qayb^{(Select a Category)} , ka dooro Xisaab iyo Trig^{(Math and Trig)} sanduuqa liiska.

Qaybta Dooro Shaqo^{(Select a Function)} , ka dooro shaqada Roomaanka^{(Roman )} liiska.

Kadib dhagsii OK .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa furmi doona.

Gudaha sanduuqa wada-hadalka ee qaybta Number , ku qor unugga A2   i gudaha sanduuqa ama guji unugga A2 , oo waxay ka muuqan doontaa sanduuqa.

Foomka^(Form) qaybta waa ikhtiyaari.

Kadib dhagsii OK .

Habka Labaad waa in la gujiyo tabka Formulas oo aad gujiso ^{(Formulas )}Xisaabta iyo^{(Math and Trig)} Badhanka Badhanka ee kooxda Maktabadda Shaqada^{(Function Library)} .

Liiska hoos-u-dhaca, dhagsii shaqada Roomaanka^{(Roman )} .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona.

Raac tillaabooyinka habka koowaad ee  Doodaha Shaqada^{(Function Arguments)} .

Waxaan rajeyneynaa in casharkaan uu kaa caawiyo inaad fahamto sida loo isticmaalo shaqada ROMN^(ROMAN) ee Microsoft Excel .

Akhri soo socda^{(Read next)} : Sida loo isticmaalo RANDBETWEEN Function gudaha Excel^{(How to use the RANDBETWEEN Function In Excel)} .

How to use the ROMAN function in Excel

The ROMAN function is a Math and Trigonometry function, and its purpose is to convert an Arabic numeral to Roman as Text. The error value #VALUE is returned If the number is negative or greater than 3999. The formula for the ROMAN function is ROMAN (number, [form]).

In this tutorial, we will explain how to use the ROMAN function. The Syntax for the ROMAN function.

       Number: The Arabic numeral to convert. It is required.

       Form: The type of Roman numeral you want. It is optional

How to use ROMAN function in Excel

Open Microsoft Excel.

Create a table.

In the cell where you want to place the result type =ROMAN(A2).

A2 is the cell that contains the arabic numeral.

Press enter on the keyboard to see the result and drag the fill handle down to see the other answers.

Method one is to click the fx button on the top left of the excel worksheet.

An Insert Function dialog box will appear.

Inside the dialog box in the section, Select a Category, select Math and Trig from the list box.

In the section Select a Function, choose the Roman function from the list.

Then click OK.

A Function Arguments dialog box will open.

Inside the dialog box in the Number section, type cell A2  inside the box or click cell A2, and it will appear in the box.

The section Form is optional.

Then click OK.

Method Two is to click the Formulas tab and click the Math and Trig button in the Function Library group.

In the drop-down list, click the Roman function.

A Function Arguments dialog box will appear.

Follow the steps in method one for  Function Arguments.

We hope this tutorial helps you understand how to use the ROMAN function in Microsoft Excel.

Read next: How to use the RANDBETWEEN Function In Excel.

Related posts

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel

• Sida loo tiriyo lambarka Haa ama Maya ee Excel

• Excel, Word ama PowerPoint ma bilaabi karaan markii ugu dambeysay

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Sida loo qaybiyo hal tiir oo loo kala qaybiyo tiirar badan oo Excel ah

• Sida loo abuuro oo loo isticmaalo Koontaroolada Foomka gudaha Excel

• Sida loogu daro Trendline xaashida shaqada ee Microsoft Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Casharka Microsoft Excel, ee Bilowga ah

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Sida loo daabaco unugyada la doortay ee Excel ama Google Sheets hal bog

• Sida loo abuuro Jaantuska Ururka gudaha Excel