Difference between revisions of "Manuals/calci/ORDINAL"
Jump to navigation
Jump to search
| (One intermediate revision by one other user not shown) | |||
| 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== | ||
| Line 15: | Line 15: | ||
#ORDINAL(22) = 22nd | #ORDINAL(22) = 22nd | ||
#ORDINAL(53) = 53rd | #ORDINAL(53) = 53rd | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=3-dvUCPeQjg|280|center|Ordinal}} | ||
==See Also== | ==See Also== | ||
Latest revision as of 23:33, 13 February 2019
ORDINAL (Number)
- is any real numbers.
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