Difference between revisions of "Manuals/calci/ROMAN"

From ZCubes Wiki
Jump to navigation Jump to search
Line 21: Line 21:
  
 
==Examples==
 
==Examples==
#=ROMAN(128,0) = Cv15529VIII(CALCI)
+
#=ROMAN(128,0) = Cv15529VIII
 
#=ROMAN(600) = DC
 
#=ROMAN(600) = DC
 
#=ROMAN(758) = DCCLVIII
 
#=ROMAN(758) = DCCLVIII
 
#=ROMAN(999,0) = CMXCIX
 
#=ROMAN(999,0) = CMXCIX
#=ROMAN(999,1 )= CMXCIX(CALCI)
+
#=ROMAN(999,1 )= CMXCIX
#=ROMAN(999,2) = CMXCIX(CALCI)
+
#=ROMAN(999,2) = CMXCIX
#=ROMAN(999,3) = CMXCIX(CALCI)
+
#=ROMAN(999,3) = CMXCIX
#=ROMAN(999,4) = CMXCIX(CALCI)
+
#=ROMAN(999,4) = CMXCIX
#=ROMAN(999,5) =  CMXCIX(CALCI)
+
#=ROMAN(999,5) =  CMXCIX
  
 
==See Also==
 
==See Also==

Revision as of 03:42, 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 for a value.

Examples

  1. =ROMAN(128,0) = Cv15529VIII
  2. =ROMAN(600) = DC
  3. =ROMAN(758) = DCCLVIII
  4. =ROMAN(999,0) = CMXCIX
  5. =ROMAN(999,1 )= CMXCIX
  6. =ROMAN(999,2) = CMXCIX
  7. =ROMAN(999,3) = CMXCIX
  8. =ROMAN(999,4) = CMXCIX
  9. =ROMAN(999,5) = CMXCIX

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