Manuals/calci/ORDINAL

Revision as of 00:33, 14 February 2019 by Swapna (talk | contribs) (→‎Description)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
ORDINAL (Number)


  • is any real numbers.

Description

  • This function shows the Ordinal value of the given number.
  • In  ,  is any real number.
  • An Ordinal Number is a number that tells the position of something in a list, such as 1st, 2nd, 3rd, 4th, 5th etc.
  • Cardinal number shows how many of something are there. Hence when Cardinal number is given, this function will show the Ordinal number.
  • When the given number is a decimal number, this function truncates it to integers.

Examples

  1. ORDINAL(1) = 1st
  2. ORDINAL(12) = 12th
  3. ORDINAL(41.3) = 41st
  4. ORDINAL(22) = 22nd
  5. ORDINAL(53) = 53rd

Related Videos

Ordinal

See Also

References