Difference between revisions of "Manuals/calci/ORDINAL"
Jump to navigation
Jump to search
Line 6: | Line 6: | ||
*In <math>ORDINAL(Number)</math>,<math>Number</math> is any real number. | *In <math>ORDINAL(Number)</math>,<math>Number</math> 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. | *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 decimal this function | + | *When the given number is a decimal number, this function truncates it to integers. |
==Examples== | ==Examples== |
Latest revision as of 23:33, 13 February 2019
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
- ORDINAL(1) = 1st
- ORDINAL(12) = 12th
- ORDINAL(41.3) = 41st
- ORDINAL(22) = 22nd
- ORDINAL(53) = 53rd