PrecisionCalc
inspector
text
Do Anything with Text in Formulas
itST
Returns the English ordinal indicator, also known as the ordinal suffix, of a cardinal number. The ordinal indicator turns a cardinal number into an ordinal number. While a cardinal number shows quantity (1, 2, 3, etc.), an ordinal number shows position in a sequence (1st, 2nd, 3rd, etc.).
Can return the complete ordinal number ("1st", "2nd", "3rd", etc.), or the ordinal indicator alone ("st", "nd", "rd", etc). Can return the ordinal indicator in lower case or upper case.
Syntax
itST(num, exclude_num, upper_case)
num | Required. The cardinal number (1, 2, 3, etc.) for which to return an ordinal indicator. |
exclude_num | Optional. Determines whether to return the ordinal indicator alone ("st", "nd", "rd", etc.) or return the complete ordinal number ("1st", "2nd", "3rd", etc). Set to TRUE to return only the ordinal indicator. FALSE by default. |
upper_case | Optional. Determines whether to return the ordinal indicator in lower case or upper case. Set to TRUE to return the ordinal indicator in upper case. FALSE by default. |
Examples
Formula | Description | Result |
=itST(1) | Return the ordinal of 1. | 1st |
=itST(1, TRUE) | Return the ordinal indicator of 1. | st |
=itST(1, , TRUE) | Return the ordinal of 1, in upper case. | 1ST |