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

 

 

PrecisionCalc Home Page