The Excel Arabic function converts a Roman numeral into an
Arabic numeral.
Syntax
The syntax for the Arabic
function in Microsoft Excel is:
=ARABIC( text )
Parameters or Arguments
text
Required. A string enclosed in
quotation marks, an empty string (""), or a reference to a cell
containing text.
Excel Arabic Function Examples
The spreadsheet below shows
five examples of the Excel Arabic Function.
Formulas:
A
|
B
|
|
1
|
=ARABIC("IV")
|
|
2
|
=ARABIC("-IV")
|
|
3
|
=ARABIC("MCXX")
|
|
4
|
MMXV
|
=ARABIC(A4)
|
5
|
=ARABIC("")
|
Results:
A
|
B
|
|
1
|
4
|
|
2
|
-4
|
|
3
|
1120
|
|
4
|
MMXV
|
2015
|
5
|
0
|
Note
Ø The
Arabic function was only introduced in Excel 2013 and so is not available in
earlier versions of Excel.
Ø If
supplied directly to the function, the text argument must be encased in
quotation marks;
Ø If
an empty text string is supplied, the Arabic function returns the value 0;
Ø If
"text" contains numbers, then #VALUE is returned.
Ø If
"text" contains dates, then #VALUE is returned.
Ø If
"text" contains text that is not valid roman numerals, then #VALUE is
returned.
Ø The
"text" has a maximum length of 255 characters.
Ø Any
leading or trailing spaces are ignored.
References
follow us on http://arivilm.blogspot.in
like us on https://www.facebook.com/Arivilm2501
No comments:
Post a Comment