Difference between revisions of "Manuals/calci/ROMAN"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''ROMAN'''(Number, Form) where, '''Number''' - are represents Arabic numeral. '''Form''' - a number speci...") |
|||
Line 1: | Line 1: | ||
− | <div | + | <div style="font-size:30px">'''ROMAN(n,t)'''</div><br/> |
+ | *<math>n</math> is the number and <math>t</math> is the type of the roman numeral. | ||
+ | |||
+ | |||
+ | ==Description== | ||
+ | *This function used to change a arabic numeral form to roman form. | ||
+ | *Romans are formed by combining symbols together and adding the values. | ||
+ | *It is the special method of showing the numbers.In roman form, numbers greater than 1,000 are formed by placing a dash over the regular symbol. | ||
+ | *In <math>ROMAN(n,t), n</math> is the Arabic number and <math>t</math> is the number which is indicating the type of the roman numeral. | ||
+ | *<math>t </math> is varying from Classic to Simplified, becoming more concise as the value of increases. | ||
+ | '''t''' value ''' Type''' | ||
+ | 0 or omitted - Classic | ||
+ | 1 - More concise | ||
+ | 2 - More concise | ||
+ | 3 - More concise | ||
+ | 4 - Simplified | ||
+ | TRUE - Classic | ||
+ | FALSE - Simplified | ||
+ | * This function will return the result as error when the n value is negative. | ||
+ | *Also there is no restriction to give a <math>n </math> value. | ||
+ | |||
+ | |||
+ | ==Examples== | ||
+ | #=ROMAN(128,0) = Cv15529VIII(CALCI) | ||
+ | #=ROMAN(600) = DC | ||
+ | #=ROMAN(758) = DCCLVIII | ||
+ | #=ROMAN(999,0) = CMXCIX | ||
+ | #=ROMAN(999,1 )= CMXCIX(CALCI) | ||
+ | #=ROMAN(999,2) = CMXCIX(CALCI) | ||
+ | #=ROMAN(999,3) = CMXCIX(CALCI) | ||
+ | #=ROMAN(999,4) = CMXCIX(CALCI) | ||
+ | #=ROMAN(999,5) = CMXCIX(CALCI) | ||
+ | |||
+ | ==See Also== | ||
+ | |||
+ | ==References== | ||
+ | |||
+ | ) where and . | ||
'''ROMAN'''(Number, Form) | '''ROMAN'''(Number, Form) | ||
Line 33: | Line 70: | ||
Lets see an example in (Column1, Row1) | Lets see an example in (Column1, Row1) | ||
− | + | UNIQ002b45fd0bb6c63b-nowiki-00000002-QINU | |
ROMAN returns MCCXXXIV. | ROMAN returns MCCXXXIV. |
Revision as of 02:34, 10 January 2014
ROMAN(n,t)
- is the number and is the type of the roman numeral.
Description
- This function used to change a arabic numeral form to roman form.
- Romans are formed by combining symbols together and adding the values.
- It is the special method of showing the numbers.In roman form, numbers greater than 1,000 are formed by placing a dash over the regular symbol.
- In is the Arabic number and is the number which is indicating the type of the roman numeral.
- is varying from Classic to Simplified, becoming more concise as the value of increases.
t value Type 0 or omitted - Classic 1 - More concise 2 - More concise 3 - More concise 4 - Simplified TRUE - Classic FALSE - Simplified
- This function will return the result as error when the n value is negative.
- Also there is no restriction to give a value.
Examples
- =ROMAN(128,0) = Cv15529VIII(CALCI)
- =ROMAN(600) = DC
- =ROMAN(758) = DCCLVIII
- =ROMAN(999,0) = CMXCIX
- =ROMAN(999,1 )= CMXCIX(CALCI)
- =ROMAN(999,2) = CMXCIX(CALCI)
- =ROMAN(999,3) = CMXCIX(CALCI)
- =ROMAN(999,4) = CMXCIX(CALCI)
- =ROMAN(999,5) = CMXCIX(CALCI)
See Also
References
) where and .
ROMAN(Number, Form)
where,
Number - are represents Arabic numeral.
Form - a number specifying the type of Roman.
Form Type
0 or omitted Classic
It converts an arabic numeral to roman.
If number is negative, ROMAN returns the #ERROR.
ROMAN
Lets see an example in (Column1, Row1)
?UNIQ002b45fd0bb6c63b-nowiki-00000002-QINU?
ROMAN returns MCCXXXIV.
Syntax
Remarks
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | MCCXXXIV | |||
Row2 | ||||
Row3 | ||||
Row4 | ||||
Row5 | ||||
Row6 |